How do I Export a table created in Word to Excel

[Guest]

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.

 

[Shauna Kelly]

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

 

[Guest]

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

 

[Cindy M -WordMVP-]

Hi =?Utf-8?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

 

[Suzanne S. Barnhill]

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

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.