Depending on the layout, that should be quite straightforward.



If the data are in a Word table, with a column per field, it should just be a matter of copy/paste. If the data are comma/tab delimited paragraphs, with a comma/tab per field, it should just be a matter of copy/paste followed by Text to Columns in Excel.

Without seeing the data, though, no-one can be absolutely sure of what might be required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for getting back to me. It is a word doc table with two columns on a page and each cell has the full address if that makes sense. is there a way I can show you?

Basically like this in each cell:

Name
Address 1
Address 2
City
Postcode