Pasting from a MS Word table to Excel - preserving carriage returns within cells

[A.Buchanan]

I have the need to transfer a large MS Word table into Excel.
Unfortunately each cell in the word table includes a number of
carriage returns. When one pastes these cell to Excel the carriage
returns cause the text following each <CR> to be pasted into a lower
cell.

How can I copy the table accross whilst preserving the carriage
returns in each copied cell ?

Alan Buchanan

(PS. It seems Word uses <CRLF> to throw a new line but Excel use just
the <LF>)

[Richard O. Neville]

Start by making a second copy of the Word table, then use the Replace
function to change all the hard returns to something else, like a space. It
should paste into Excel with no trouble. The only way to place what you call
a "carriage return" within an Excel cell is to hold down the Alt key while
hitting the Enter key. You may have to do this manually.

"A.Buchanan" <alan.b...@Clarks.com> wrote in message
news:565eb58d.0305...@posting.google.com...

[Dave Peterson]

I like Richard's answer.

But I think I'd pick a character that doesn't appear anywhere in the data in
MSWord. (Like a vertical bar |).

then in Word
select your table
Edit|replace
And replace both the "paragraph mark" and the "manual page break".
(You can find them under the "special" button in Word's find dialog)
(They both cause problems in excel.)

Change them both to the unique character.

Paste into Excel.
Select the range of cells and do
Edit|replace
change the unique character (|) to alt-enter's.
Hit and hold the Alt key and type 0010 into the "replace with" box.
(alt-0010: That 0010 is typed using the number keypad--not the keys above
QWERT.)

It may not look like it took, but you'll see the results when you hit the
"replace all"

If you do this, you'll get the same linebreaks that you had in Word (maybe widen
the columns).

--

Dave Peterson
ec3...@msn.com