fecan

Thank you! I will give it a go and let you know how I went. Regards, Duncan.

Hi Lee, Thank you very much for your reply. It was so fast! The database was purchased with the fields already set up with the address in one field. The data has already been imported (there are about 10,000 records) The data in this particular field is laid out exactly as 1234/100 Smith street. I need 3 new fields to work out and display: *unit number is to the left of the forward slash *street number is to the right of the forward slash *street name is to the right of the first space. *ignore any other spaces. (or make it a forth field being street type- not necessary though) Apologies if I am still unclear, I am not sure how else to explain it but will keep at it if I am making sense at all. Thanks again, Duncan.

Hi, does someone know how i would separate an address field that is currently entered as "1234/100 Smith Street" =(owner_address) into "1234" as (Owner_unit), "100" (owner_street_number) "smith" as (owner_street) I am a newbie with basic knowledge. I am guessing i need to create 3 new fields with the formulas to automatically pull them from the one field. Thank you in advance, any help would be much appreciated.