copying word tables that have carriage returns in a cell

[Pete Webb]

Is there a way to properly copy table cell data
containing 'internal' carriage returns into an equivalent
cell in Excel?

 

[Andy Brown]

"Pete Webb",

In the (Edit >>) Replace dialog in Word 6, there's a More button. Click it &
there's a Special button. One option is manual line break, selecting this
puts the relevant character into the Find What box. Replace with something
unique, eg: $$$.

Copy the table. In Excel, (Edit >>) Paste Special as Text. Then Replace
again ; Find What = $$$. Click in the Replace With box, type 0013 on the
number keypad while holding down ALT.

You may need to format the cell(s) as Text and turn Text Wrapping (Alignment
tab) on. Or not. Experiment.

HTH,
Andy

 

[Andy Brown]

Andy,

Thanks for the input. I had done everything that you
suggested except that I didn't know what the replace with
should be. Alt 0013 (on the keyboard) did not work. I
didn't mention that I am using Word 2000 at work. The
word part worked, but Excel will not take Alt 0013 as an
input.

Thanks for the effort though. If you think of anything
else, I sure would appreciate it.

thanks again,

Pete

 

[Pete Webb]

-----Original Message-----

How about ALT0010 ?

Well Andy, I guess I wasn't holding my mouth right. Now,
though, I am getting 5 or 6 carriage returns in the cell.

I really appreciate this. I am now on the right track. I
was completely at a stand still.

Pete

 

[Pete Webb]

Andy, Just to close the loop. Success!!!! The reason I
was getting multiple carriage returns was that I was not
removing all the previous trys. back space doesn't do
it. I hit delete several times and got them out of the
replace line.

Also, just to admit my dumbness, the reason it didn't work
the first time is because I was hitting replace instead of
replace all, and I was not in the cell I was trying to
replace.

Thanks again.

Pete