Then first separate them with Data/Text to columns!

Regards,
Stefi


€žPatrick Bateman€� ezt Ã*rta:

Hi thankyou, but that didnt work, i may not have explained properly, all the
address information is in one cell.

regards

Patrick


"Stefi" wrote:

Try PasteSpecial/Transpose!

Regards,
Stefi


€žPatrick Bateman€� ezt Ã*rta:

Hi, i am pulling through and address from a query which is in the form:

NameNumberStreettownpostco de

and i need it to populate cells in the form:

Name
Number
Street
town
Postcode

any ideas how?

any help would be much appreciated

regards

Patrick