Pasting from Word Table
Thanks for the suggestion. That puts them all in one cell, but it doesn't
address the issue of then wanting the data to look like a formatted address
label within that cell.
I figured out a workaround:
1) Replace the line breaks in the Word document with a unique character
string. Then when that's pasted into Excel, the lines don't break and
everything stays in one cell with the string temporarily substituting for the
line break.
2) Then do a find/replace, finding the string and replacing it with a Ctrl-j
(which become your line breaks within the cell, or the equivalent of typing
Alt-Enter).
"Stout" wrote:
not sure about the "alt-enter" but you can get them in one cell by:
Assuming the address pastes in A1, B1,C1.
In D1, type "=a1&b1&c1" for spaces in between the address cells try =A2&"
"&B2&" "&C2
Then copy D1, go to Editpaste specialvalues.
|