Adding text Left and Right of a field

[lennymos123]

I'm using a datefeed that needs some attention to before uploading to actinic . When the feed comes the one field is in HTML i need to put "!!<" at the start of the Field and ">!!" at the end of the field so it reads HTML when uploaded.. So i need to add this to one field with 250 records anyone got any ideas

PAul

[jont]

Depends if the HTML is the same throughout or to a set variation - you could use a find and replace function in the external feed to add the !!< >!! for Actinic.

[pinbrook]

use the concatenate formula. You may have to do it twice.

once to concatenate the !!< to the beginning of the cell and then again to concatenate to the end