Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word to Excel (line breaks)

    OK, What I've got is a Word 2000 document that I need to import into Excel 2000. Some lines in Word are broken up by manual line breaks (^l) and some by carriage returns (^p). I want the lines with line breaks at the end to all show up in a single Excel cell, each on its own line within the cell (normally created in Excel by using ALT+ENTER). The lines with paragraph marks will indicate a new cell in Excel (it normally does this anyway). The resulting Excel worksheet will only be 1 column wide.

    I've thought about trying to perform some sort of find/replace in Word to replace line breaks with the character code for ALT+ENTER and then doing a copy/paste or import, but I don't know the code to use or if this is even possible.

    Any suggestions?

    Mark

    (I'm cross-posting this message to the Excel forum.)

  2. #2
    New Lounger
    Join Date
    Feb 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word to Excel (line breaks)

    Thanks to Catharine, who found a solution to this...

    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=38850&page=0& view=&sb=&part=&vc=1>http://www.wopr.com/cgi-bin/w3t/showthread...&sb=&part=&vc=1</A>

    Mark

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •