Pasting from Word Table
Saved from a previous post:
If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.
One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.
I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with: $$$$$ (if $$$$$ doesn't appear in the table)
replace all
Same thing with Manual Line break (from under Special).
Now copy the table into Excel.
Edit|Replace
Replace what: $$$$$
Replace with: ctrl-j
replace all.
You may have to use Format|cells|Alignment tab|check wrap text
Don't forget to close the word document without saving (or hit undo as many
times as necessary).
Eric wrote:
I'm trying to copy a Word table into Excel. My table contains address labels
with name, address, city/state/zip on three lines (separated by a line break)
within each cell of the Word table.
When copying into Excel, the address data pastes over as three separate
cells. Any (non-Visual Basic) ideas on how I can get it to all paste into one
cell (as if typed into the cell with an alt-Enter after every line)?
TIA!
--
Dave Peterson
|