Can Word replace CR/LF with LF?

Discussion in 'Microsoft Word Document Management' started by Al, Jun 10, 2006.

  1. Al

    Al Guest

    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.
     
    Al, Jun 10, 2006
    #1
    1. Advertisements

  2. Al

    Graham Mayor Guest

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

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

    My web site www.gmayor.com

    <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
     
    Graham Mayor, Jun 11, 2006
    #2
    1. Advertisements

  3. Al

    Graham Mayor Guest

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

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

    My web site www.gmayor.com

    <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
     
    Graham Mayor, Jun 11, 2006
    #3
  4. 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.
     
    Suzanne S. Barnhill, Jun 11, 2006
    #4
  5. 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.
     
    Suzanne S. Barnhill, Jun 11, 2006
    #5
  6. Al

    Al Guest

    Suzanne is correct(no surprise, she always is!). ^l is treated the same as
    ^p by Excel. It is the first thing I tried.
     
    Al, Jun 11, 2006
    #6
  7. Al

    Al Guest

    Suzanne is correct(no surprise, she always is!). ^l is treated the same as
    ^p by Excel. It is the first thing I tried.
     
    Al, Jun 11, 2006
    #7
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.