Can Word replace CR/LF with LF?

[Al]

I have a Word table and want to save it as an Excel CSV. If it is pasted
into Excel, any cell which contains a Pilcrow (Word CR/LF) is treated in
Excel as a merged cell and Excel will not allow the spreadsheet to be saved
as CSV. In Excel, cells which are multiple lines have just LF (OA rather
than OD OA).
Saving it in Word by converting the Table to text with comma as delimiter
does not work, since the cells contain commas. The format for Excel CSV
is comma delimited unless the cell contains a comma then the cell is also
enclosed in quotes. My memory is failing (just celebrated 65 birthday) but
this seems like the old mail merge format.
I have overcome this by replacing the CR/LF with a unique character (~),
then pasting table in Excel, then saving as CSV. Then opening the CSV in
Word and replacing the ~ with ^p (CR/LF). Excel will open this without
considering the CR/LF as merged cells. It does not like the CR/LF and
displays a box. I think I could solve the problem if I could replace CR/LF
with LF only in Word.
I am using Word 2002.

 

[Graham Mayor]

Replace ^p with ^l - but I don't think it is going to help?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Suzanne S. Barnhill]

No, sadly, Excel will treat the line break the same as a paragraph break; I
think Al will have to resign himself to using ~ or some similar device.

 

[Al]

No, sadly, Excel will treat the line break the same as a paragraph
break; I think Al will have to resign himself to using ~ or some
similar device.

Suzanne is correct(no surprise, she always is!). ^l is treated the same as
^p by Excel. It is the first thing I tried.