la90292
05-26-2021, 08:43 PM
Hello,
I have a list where the property address is in column B as follows:
# Property Address
1. 123 N Maple Dr, Los Angeles, CA 90000
2. 129 W Main St Unit 2, Los Angeles, CA 90000
3. 111 Main Ave, STE 1, Los Angeles, CA 90000
I would like to select all the records in that column and split the date to separate columns as follows:
Street #
Street Address
City
ST
Zip
123
N Maple St
Los Angeles
CA
90000
129
W Main St Unit 2
Los Angeles
CA
90000
111
Main Ave, STE 1
Los Angeles
CA
90000
Note that record 2 & 3, Unit 2 is not separated by a comma whereas record 3 is.
Then I would like the list sorted by City, Zip, Street Address, Street #.
Thank you for your help.
I have a list where the property address is in column B as follows:
# Property Address
1. 123 N Maple Dr, Los Angeles, CA 90000
2. 129 W Main St Unit 2, Los Angeles, CA 90000
3. 111 Main Ave, STE 1, Los Angeles, CA 90000
I would like to select all the records in that column and split the date to separate columns as follows:
Street #
Street Address
City
ST
Zip
123
N Maple St
Los Angeles
CA
90000
129
W Main St Unit 2
Los Angeles
CA
90000
111
Main Ave, STE 1
Los Angeles
CA
90000
Note that record 2 & 3, Unit 2 is not separated by a comma whereas record 3 is.
Then I would like the list sorted by City, Zip, Street Address, Street #.
Thank you for your help.