how to - Insert predifined text in each cell of a column

[npereira]

Hi all,

I have a CSV file with 19 columns and about 500 rows.
In the column D, there is text (html) in all 500 rows.
I need to know how to prepend and append a predifined text to th
begining and end of each cell in column D.

ex: Cell D2 has text of ' <P>class info for today. <B>When?</B></P> '
I need the cell to be modified so that ' <table><tr><td> ' be prepen
the text above and that ' </td></tr></table> ' be appended to the tex
also so that the cell will now read:

<table><tr><td><P>class info for today
<B>When?</B></P></td></tr></table>

How can I acheive this?

Thanks for your help

 

[swatsp0p]

Assuming you want the same text prepended and appended to each of the
500 cells, you could insert a blank column next to D. In a blank
section of your sheet (columns U and V?) enter your prepend values in
one cell (U1) and append values in another (V1).

In your new, blank E1, enter this formula:

=$U$1&D1&$V$1

copy this down 500 rows.

Now, copy column E, Paste Special Values over top of itself and then
Delete Column D

Good Luck

 

[npereira]

Worked like a charm Bruce... Thanks !

 

[swatsp0p]

I'm glad it worked for you. Thanks for the feedback, it is alway
appreciated.

Cheers