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



"John" wrote:

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?