| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert cell text every 5 rows in a column | Excel Discussion (Misc queries) | |||
| Insert Column after specific text title the new column and add for | Excel Discussion (Misc queries) | |||
| when the column text is different, how to insert one row below eac | Excel Worksheet Functions | |||
| Insert cell/format/text/fontsize and auto insert into header? | Excel Programming | |||
| insert 3 rows before any text in column A | Excel Programming | |||
![npereira[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
