copy tables from word into excel, without merging cells

Hi guys,


I have a word document with a table 3 columns and many rows, some of the rows have multiple lines in them, using enter and ctrl enter.
When I copy and paste the table into excel, all the columns line up. However the rows do funny things like merge 2 rows together if the word document had any Ctrl+Enters within a table cell.


I need a way that will copy a table from word to excel without merging cells. I would imagine excel would use the "Alt+Enter" (new line within same cell) instead of putting information on the next row, and merging other rows.

Thanks guys
Jimmy

Hi Jimmy,

Its not the complex task, just you need to take care of the table selected in Word while copying, It would be better to enclose the sample file to see the issue.

Originally Posted by Sunny18pc

...sample file to see the issue.

See attached
Example.docx


Try copying and pasting either table into excel and they both end up all weird. Any help would be greatly appreciated.

*Bumping this thread*

Hi,

I downloaded your word file and copied the tables into excel, unchecked "Wrap Text" option first selecting the whole data range, adjusted the column width and applied the "Wrap Text" again.

See the attached file. Is this not what you get when you paste the word file that you posted into excel in your computer?

Originally Posted by cbatrody

Hi,

I downloaded your word file and copied the tables into excel, unchecked "Wrap Text" option first selecting the whole data range, adjusted the column width and applied the "Wrap Text" again.

See the attached file. Is this not what you get when you paste the word file that you posted into excel in your computer?

Your attached file is what I get when I copy and paste; not correct formatting.

Originally Posted by macropod

The problem with what you're trying to do is that the table cells contain paragraph breaks and line breaks. Excel can't handle these as part of a single cell's pasted content from Word. Hence the use of a separate row for each paragraph and the merging of cells in adjoining columns.

A workaround is to use Find/Replace in Word to replace those paragraph breaks and line breaks with some other temporary character (e.g. ASCII 182 = ¶), do the paste, then replace those temporary characters in Excel with line breaks (ASCII 10).

Works pretty well. can't believe I didn't try that..

I'm using ^p in find and replace.
How do I take care of the "Shift+ Enter" the same way in word?

Originally Posted by macropod

Use ^l as the Find expression.

That might just do it.