+ Reply to Thread
Results 1 to 2 of 2

Copy text from Word to Excel

  1. 07-31-2011, 07:53 AM #1
    Sandra V
    Sandra V is offline
    Registered User
    Join Date
    07-31-2011
    Location
    Gent, Belgium
    MS-Off Ver
    Excel 2003
    Posts
    2

    Copy text from Word to Excel

    Hi, I hope that someone could help me.

    I have a text in Word which I want to transfer to Excel. A number of the words/sentences need to be in the same cell in Excel. When I copied the text from Word into Excel, each word/sentence was pasted into a separate cell. Does anyone know how I can paste them from Word to Excel correctly or edit the Excel file easily?

    Thanks in advance for your help!
    Reply With QuoteRegister To Reply
  2. 07-31-2011, 10:44 AM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Copy text from Word to Excel

    Copying Word tables to Excel will cause strange results with complex tables, such as ones with merged or split cells, and cells with text having paragraph breaks. If you have those kinds of troubles then a VBA macro may be necessary. Can you post an example of your Word file?

    Someone asked exactly the same question last year and it does not appear that it was resolved.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1