annegrey
New Member
- Joined
- Nov 17, 2005
- Messages
- 32
Hi
I have a list of text as follows:
Port Melbourne Vic 3207
Clifton Hill Vic 3068
Melbourne Vic 3001
South Melbourne Vic 3205
Lorne Vic 3232
Lorne Vic 3232
I want to separate the City, State and Postcode into 3 columns. Any help will be appreciated.
Thanks
AG
I have a list of text as follows:
Port Melbourne Vic 3207
Clifton Hill Vic 3068
Melbourne Vic 3001
South Melbourne Vic 3205
Lorne Vic 3232
Lorne Vic 3232
I want to separate the City, State and Postcode into 3 columns. Any help will be appreciated.
Thanks
AG