copy tables from word into excel, without merging cells

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.