Practically speaking, you can accomplish this IF you have the same # of lines
for each set of contacts, i.e., if they all have 5 lines (even if some lines
are blank). Even if this is o, it'll still be very messy, unless the City is
ALWAYS on the same numbered line, and the State is ALWAYS on the same
numbered line, etc.

If there is some absolutely consistent way of telling when one address ends
and the next starts you can sorta/kinda do it, but it will definitely be a
mess because you'll have different types of values in the same column. For
instance, in column C one row will show Suite 200 & the next row will show
Denver

So...how is your data laid out?


"longer" wrote:

I have a vertical list in Word that has for instance a person's name on line
one, the address on line 2, etc. I am trying to get that list moved over to
Excel, so that the info on line one will be in column A, info on line 2 to be
on column B, etc. How can I do this?
--
Longer