Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Opening a csv file in word
Hi, I'm having a problem at the moment - I need to do a large find & replace with my excel data. I actually do two, the first one works fine but the second one doesn't; The first one I just open my.csv file in word, do my find and replace, save again and it opens fine in excel. The second one though, I need to find and replace the paragraph breaks and replace them with the tag <br /. When I save it again and open in excel, my results are displayed across the top row instead of the column, and they're no longer in a single cell for each record. I'm guessing it's because I take away all of the blank lines from word but I'm not sure. does anyone have any suggestions how I could sort it? Regards, Saybut. -- saybut ------------------------------------------------------------------------ saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949 View this thread: http://www.excelforum.com/showthread...hreadid=468854 |
#2
|
|||
|
|||
Likely, you shouldn't REPLACE the breaks, but just add the tag to the break,
something like replace ^p with <br/^p ************ Anne Troy www.OfficeArticles.com "saybut" wrote in message ... Hi, I'm having a problem at the moment - I need to do a large find & replace with my excel data. I actually do two, the first one works fine but the second one doesn't; The first one I just open my.csv file in word, do my find and replace, save again and it opens fine in excel. The second one though, I need to find and replace the paragraph breaks and replace them with the tag <br /. When I save it again and open in excel, my results are displayed across the top row instead of the column, and they're no longer in a single cell for each record. I'm guessing it's because I take away all of the blank lines from word but I'm not sure. does anyone have any suggestions how I could sort it? Regards, Saybut. -- saybut ------------------------------------------------------------------------ saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949 View this thread: http://www.excelforum.com/showthread...hreadid=468854 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you open a template at startup? | Excel Discussion (Misc queries) | |||
why does my file name get suffixed with a number when opening ? | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions | |||
Opening a file with a Macro | Excel Discussion (Misc queries) | |||
restrict opening Excel file residing on a shared drive to one user | Excel Discussion (Misc queries) |