Address in excel
this partly works when i do it but is it possible for it to be done
automatically as each different address is pulled through from the query?
regards
patrick
"Stefi" wrote:
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:
NameNumberStreettownpostco 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
|