Quote:
Originally Posted by macropod
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.
|
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