Pasting a block of Word info into a single Excel cell

[Guest]

Hello -- we have a list of names and addresses Word in non-uniform format.

One address might be
John Smith
24 Oak Drive
Town, full name of state, zip
(Mary and Clarence)

Another address might be
Mr. and Mrs. John Jones
(Diane and Dick)
Fifty three Oak Drive
Town, NY, 88888
(Phone number)

In other words, these blocks of info have varying info on different lines
and have varying numbers of lines.

What I would like to do is copy/paste each block into a SINGLE Excel cell.
Then I can manually add columns like fname and lname -- then run counts, etc.
But when I paste from Word into an Excel cell, the address info puts each
line into a separate cell. How can I tell it to put all four lines of info
(or five lines of info) into a single cell, making it look in Excel just like
the address datum in the Word list?

Many thanks

 

[PCLIVE]

If you are copying and pasting one at a time (meaning, one name and address
and phone number if applicable), then you can paste the info into the
formula bar. Or...double-click on the cell so that a blinking cursor is in
it before pasting.

Good luck.
Paul

 

[Guest]

Hmmm -- Doh! -- didn't think of this -- seems to work. Many thanks.

 

[Gord Dibben]

I would advise against putting all that data in one cell.

You would find great difficulty with filtering, sorting and especially
separating fnames and lnames from a single block.


Gord Dibben MS Excel MVP