gregfthompson
asked on
Excel - text to column problem
The attached file has a list of addresses. The addresses often include several commas.
I want to separate the suburb which will be all of the words are after the last comma, and leave the rest of the address untouched.
Example file attached with original and required.
Thanks,
Greg
EXAMPLE-SUBURB-TO-BE-SEPARATED.xlsx
I want to separate the suburb which will be all of the words are after the last comma, and leave the rest of the address untouched.
Example file attached with original and required.
Thanks,
Greg
EXAMPLE-SUBURB-TO-BE-SEPARATED.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER