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