Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Dec 2002
    Location
    San Francisco, California, USA
    Posts
    54
    Thanks
    6
    Thanked 1 Time in 1 Post

    Excel Past (2003)

    I have text in Word 2003 that I want to paste into Excel 2003. The problem I'm having is that when a paragraph in Word contains a soft return (In Word: Shift+Enter) and I try to paste it into Excel, the soft return converts to a hard return and the pasted dated appears in two separate cells. I need the entire string (including soft return) to paste into Excel into one Cell. That is, I want the Word soft return to stay with the Excel string data so that it converts to a line break (Alt+Enter) in the same Excel cell. Does this make sense?

    Any suggestions?

    Thanks,
    Larry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Past (2003)

    If there are only soft returns in the text you copy and paste, try this:
    - Select the cell where you want to paste.
    - Click in the formula bar (or double click the cell),
    - Press Ctrl+V to paste the text.

  3. #3
    Star Lounger
    Join Date
    Dec 2002
    Location
    San Francisco, California, USA
    Posts
    54
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Excel Past (2003)

    Thanks Hans. That's great for one paragraph but I have hundreds of paragraphs in Word I need to bring over to Excel. I had hoped that I could just copy the hundreds of paragraphs, which contain soft returns and paste them into Excel.

    Any suggestions?
    Larry

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Past (2003)

    In Word, select Edit | Replace...
    Enter <code>^l</code> (that is a "hat" followed by a lower case L) in the Find What box.
    Enter a character or series of characters in the Replace with boxt hat doesn't occur in the document, e.g. a vertical line character |.
    Click Replace All.
    Copy the text to the clipboard.

    In Excel, paste the normal way.
    Select Edit | Replace...
    Enter the replacement character(s) you used above in the Find what box.
    Click in the Replace with box and type Alt+0010 (use the numeric keypad)
    Click Replace All.

    (Note: please forgive me, but I always get suspicious when people want to copy hundreds of paragraphs from Word to Excel. Excel is not a text processor.)

  5. #5
    Star Lounger
    Join Date
    Dec 2002
    Location
    San Francisco, California, USA
    Posts
    54
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Excel Past (2003)

    Hans, you're great. I agree Excel is not a text processor but a client requested the Word table that contains the data in Excel. I agree it's not the best way to handle it.

    Thanks for your suggestion, I'm going to try it immediately.

    Larry

Posting Permissions

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