Excel file: separate info from one column into multiple columns.
Budget: $10 – $30 AUD
Hi,
I have an excel file with 2 columns currently. One column has an Australian state and another one has suburb and postcode in one column.. I need them separated so that suburb name is in one column and postcode in a separate one. Some suburb names are one word, some 2 or 3 words..
Screenshot of what I have attached.
There are almost 17000 rows there.
Thanks.
I have an excel file with 2 columns currently. One column has an Australian state and another one has suburb and postcode in one column.. I need them separated so that suburb name is in one column and postcode in a separate one. Some suburb names are one word, some 2 or 3 words..
Screenshot of what I have attached.
There are almost 17000 rows there.
Thanks.