Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Copy word table to Excel w/o splitting row
I copy/paste a word table (which is an address list with over 2,000 names) to
Excel. When I pasted the table in Excel, the column "Address" which may have two lines of information and would be separated by a hard return (when working in tables with Word) it took the second line of information and started a new row. Which means it split the information in the row. How can I prevent this? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Copy word table to Excel w/o splitting row
Have you tried, in Excel, to choose Paste Special on the Edit menu,
and pick the "Text" option? (Of course, this won't preserve the font formatting from Word.) -- Stefan Blom Microsoft Word MVP "Dorna Tucker" wrote in message ... I copy/paste a word table (which is an address list with over 2,000 names) to Excel. When I pasted the table in Excel, the column "Address" which may have two lines of information and would be separated by a hard return (when working in tables with Word) it took the second line of information and started a new row. Which means it split the information in the row. How can I prevent this? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Copy word table to Excel w/o splitting row
Yes, I have. I'm getting the same results.
"Stefan Blom" wrote: Have you tried, in Excel, to choose Paste Special on the Edit menu, and pick the "Text" option? (Of course, this won't preserve the font formatting from Word.) -- Stefan Blom Microsoft Word MVP "Dorna Tucker" wrote in message ... I copy/paste a word table (which is an address list with over 2,000 names) to Excel. When I pasted the table in Excel, the column "Address" which may have two lines of information and would be separated by a hard return (when working in tables with Word) it took the second line of information and started a new row. Which means it split the information in the row. How can I prevent this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hard space between words. | Microsoft Word Help | |||
Inserting Excel tables into Word | Microsoft Word Help | |||
How do I Export a table created in Word to Excel | Microsoft Word Help | |||
Macros - Keyboard Commands | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users |