Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I Export a table created in Word to Excel
I've got a table I've created in Word 2002 and I'd like to export it or paste
it into an Excel spreadsheet. When I paste the copied table into Excel the formatting displayed is incorrect. In Word for example I've got a a row that contains 15 line in this one record. When I paste it into Excel, Excel sees those lines individually and creates a row for each. Is there a simple way to transfer this table to Excel and still maintain all the formatting? Any help you could offer would be greatly appreciated. Thank you in advance. -- Angela |
#2
|
|||
|
|||
Hi Angela
There are things that Word can do in a table that Excel can't do. And there are things that Excel can do that Word can't do. So when we copy a table from Word to Excel, Excel does its best and interprets what you paste in its own way. It is particularly unforgiving if you had more than one paragraph in a cell in Word, or if you used New Line breaks in a cell in a Word table. Excel will interpret each paragraph or each line to be a separate cell. And it will merge adjacent cells to try to replicate Word's formatting to some extent. However, there may be some ways to format your Excel spreadsheet the way you want it. Post a question to one of the Microsoft Excel newsgroups. Let them know what you are seeing in Excel and what you would like to see. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "Angela" wrote in message ... I've got a table I've created in Word 2002 and I'd like to export it or paste it into an Excel spreadsheet. When I paste the copied table into Excel the formatting displayed is incorrect. In Word for example I've got a a row that contains 15 line in this one record. When I paste it into Excel, Excel sees those lines individually and creates a row for each. Is there a simple way to transfer this table to Excel and still maintain all the formatting? Any help you could offer would be greatly appreciated. Thank you in advance. -- Angela |
#3
|
|||
|
|||
Hi Shauna and Angela... I am having the exact same problem. I need to paste
a Word table into Excel, where the cells contain paragraph markers, and I need the cells in Excel to look exactly like they do in Word. Did you ever get a response from anyone on the Excel newsgroups? I have posted this question out there today but then ran across your thread below... thanks, Steve "Shauna Kelly" wrote: Hi Angela There are things that Word can do in a table that Excel can't do. And there are things that Excel can do that Word can't do. So when we copy a table from Word to Excel, Excel does its best and interprets what you paste in its own way. It is particularly unforgiving if you had more than one paragraph in a cell in Word, or if you used New Line breaks in a cell in a Word table. Excel will interpret each paragraph or each line to be a separate cell. And it will merge adjacent cells to try to replicate Word's formatting to some extent. However, there may be some ways to format your Excel spreadsheet the way you want it. Post a question to one of the Microsoft Excel newsgroups. Let them know what you are seeing in Excel and what you would like to see. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "Angela" wrote in message ... I've got a table I've created in Word 2002 and I'd like to export it or paste it into an Excel spreadsheet. When I paste the copied table into Excel the formatting displayed is incorrect. In Word for example I've got a a row that contains 15 line in this one record. When I paste it into Excel, Excel sees those lines individually and creates a row for each. Is there a simple way to transfer this table to Excel and still maintain all the formatting? Any help you could offer would be greatly appreciated. Thank you in advance. -- Angela |
#4
|
|||
|
|||
Hi ?B?U3RldmU=?=,
I am having the exact same problem. I need to paste a Word table into Excel, where the cells contain paragraph markers, and I need the cells in Excel to look exactly like they do in Word. Basically, you need to use Find/Replace in Word to change the paragraph marks into something else (some character you don't otherwise use in your text). Now you can copy and paste into Excel, retaining the same cell layout/structure. In Excel, Find/Replace the special character with the invisible character you get when you press Ctrl+J (a newline character in Excel) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#5
|
|||
|
|||
Hmm. I never knew the Ctrl+J shortcut; I've been using Alt+Enter (discovered
accidentally). . . . I just tried Ctrl+J, and it doesn't do anything here; perhaps you have assigned a keyboard shortcut somehow? Okay, I now realize you use Ctrl+J to insert into the "Replace with" box the character entered with Alt+Enter in the sheet itself. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cindy M -WordMVP-" wrote in message news:VA.0000b029.007bd80a@speedy... Hi ?B?U3RldmU=?=, I am having the exact same problem. I need to paste a Word table into Excel, where the cells contain paragraph markers, and I need the cells in Excel to look exactly like they do in Word. Basically, you need to use Find/Replace in Word to change the paragraph marks into something else (some character you don't otherwise use in your text). Now you can copy and paste into Excel, retaining the same cell layout/structure. In Excel, Find/Replace the special character with the invisible character you get when you press Ctrl+J (a newline character in Excel) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
How do I extend an Excel table to another page in Word? | Tables | |||
WP Delay Code - Word Equiv | Microsoft Word Help | |||
Table headers | New Users | |||
Excel Link: Adding rows in Excel does not add cells in Word | Tables |