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

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

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

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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=477207

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

Worked like a charm Bruce... Thanks !


--
npereira
------------------------------------------------------------------------
npereira's Profile: http://www.excelforum.com/member.php...o&userid=10799
View this thread: http://www.excelforum.com/showthread...hreadid=477207

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

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

Cheers

--
swatsp0

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