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 ' <Pclass info for today. <BWhen?</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<Pclass info for today
<BWhen?</B</P</td</tr</table

How can I acheive this?

Thanks for your help

--
npereir
-----------------------------------------------------------------------
npereira's Profile: http://www.excelforum.com/member.php...fo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=47720