Can Word replace CR/LF with LF?


A

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.
 
G

Graham Mayor

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

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Ad

Advertisements

G

Graham Mayor

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

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
S

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.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
S

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.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
A

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.
 
Ad

Advertisements

A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top