copy a table from word to excel as cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg Middleton - 11 Dec 2007 23:49 GMT

I have a table that has been created in Word that i want to copy to Excel.
Specifically I want each cell in the word table to correspond to a single
cell in excel.

I'm running into a problem where Returns were used to seperate the text in a
cell. when this cell goes to excel, the returns result in each line of text
being a new excel cell.

Versus the ability to use alt-Return in excel to put carriage returns inside
a cell for text formatting???

Reply to this Message

garfield-n-odie [MVP] - 12 Dec 2007 05:54 GMT

You can use Alt+Enter in Word too. Since you didn't, you can use the
Edit | Replace command in Word to search the table for paragraph marks
and replace with line breaks.

> I have a table that has been created in Word that i want to copy to Excel.
> Specifically I want each cell in the word table to correspond to a single
[quoted text clipped - 6 lines]
> Versus the ability to use alt-Return in excel to put carriage returns inside
> a cell for text formatting???

Reply to this Message

nathan589@hotmail.com - 12 Dec 2007 07:51 GMT

hey im new to google and not sure how to make my own forum thing
please help me im desprate this is what i need help with.

All the key things on google such as : web : images :news :maps etc
has moved to the top left of my computer screen nothing else just my
main searching tools :S

please help its soo annoying

i really need help

Sorry but this has nothing to do about this topic

Reply to this Message

Suzanne S. Barnhill - 12 Dec 2007 14:27 GMT

Being new to Google has nothing to do with the way this newsgroup operates,
and your question has nothing to do with tables in Microsoft Word.

Signature

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

> hey im new to google and not sure how to make my own forum thing
> please help me im desprate this is what i need help with.
[quoted text clipped - 8 lines]
>
> Sorry but this has nothing to do about this topic

Reply to this Message

Greg Middleton - 12 Dec 2007 18:44 GMT

That's what I thought, but that doesn't work.

I did Find/replace Paragraph Mark/Manual Line Break.

Did a Select on the entire Table and then paste into excel. same result, it
splits the Manual Line Breaks into a new row in excel.

I'm using Word 2007/Excel 2007; sp1

> You can use Alt+Enter in Word too. Since you didn't, you can use the
> Edit | Replace command in Word to search the table for paragraph marks
[quoted text clipped - 10 lines]
> > Versus the ability to use alt-Return in excel to put carriage returns inside
> > a cell for text formatting???

Reply to this Message

nathan589@hotmail.com - 14 Dec 2007 15:53 GMT

how do i make my own group thing then...

Reply to this Message