merge a wordfile of names & addresses to an excel separate cells

J

John

Hi,

I have many names and addresses in a word file presented in list such as;

Mr John Banana
207 S. Fruit St
Health City, IL 18724

Mrs Gwen Pineapple
etc...

and I want to get them into an excel file to add to a database that i have
any ideas?
 
S

SongBear

John,
I just created a list of bogus addresses in Word and copied/pasted it into
an empty Excel worksheet.

Need more information about what you are actually trying to do; such as
where is this database, in Excel or Access?

How many address are there and are they all three lines?

Are the addresses all in one long column or in a grid, (two or three
columns) such as a label print sheet?

Does the column (or do the columns) start at the very top of the page, or is
there some text, such as an introductory or explanative paragraph, above the
first address in the list?

If you are needing to just flatten the addresses out into rows, then this
will more easily be done after the addresses are moved into Excel.

If you cannot copy/paste them into Excel and need a macro to move them, then
more information about where they are on the page (multiple columns, not at
the top of the page) and more details about the individual records
(Consistency: all three lines each?) will be needed.
SongBear
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top