Importing list from Word to Excel

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

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

The data is laid out on a Word doc as follows:
Jane Smith
123 Apple Street
Anytime, FL 55555

Bob Smith
125 Candy Lane
Anywhere, AL 33333

Etc. I want to get this over to Excel so that the name will be in column A,
the address in B. How would I do this? I tried mail merge, saving the doc
in xml format and then opening the xml doc from Excel....
--
Longer


"Duke Carey" wrote:

> 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

Copy the Word data and paste it into Excel - it should all end up in a single
column. Let's assume you paste it into column A, starting in row 1. Paste
this formula into B1, then copy it across to D1. Then you can copy those
three cells down as far as needed

=OFFSET($A1,COLUMN(A1)-1+(ROW(A1)-1)*3,0)


"longer" wrote:

> The data is laid out on a Word doc as follows:
> Jane Smith
> 123 Apple Street
> Anytime, FL 55555
>
> Bob Smith
> 125 Candy Lane
> Anywhere, AL 33333
>
> Etc. I want to get this over to Excel so that the name will be in column A,
> the address in B. How would I do this? I tried mail merge, saving the doc
> in xml format and then opening the xml doc from Excel....
> --
> Longer
>
>
> "Duke Carey" wrote:
>
> > 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