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

**npereira** · 10-18-2005, 12:36 PM

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 the 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 prepend the text above and that ' </td></tr></table> ' be appended to the text 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** · 10-18-2005, 12:46 PM

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