I have a database of addresses within Australia.
it is like:
123 Smith Road Jonesville Victoria 3000
Is there a macro or script available to split the addresses from one cell into 6 ?
The data is separated by either one or two spaces, so I think the search would be for any space (or two spaces) then place text into a separate cell. I need this to run across the page, the entire address is located in Column D and I require the outcomes to start from column J then K, L, M, N and O respectively.
Column J would then = 123
Column K would then = Smith
Column L would then = Road
Column M would then = Jonesville
Column N would then = Victoria
Column O would then = 3000
I hope someone can help, I have almost 5,500 addresses to sort. The Post Codes are my starting point and this is how I believe I can solve my problem.
Bookmarks