cansevin
asked on
Pull City out of excel
I have a column of addresses that are all in this form:
"11493 East Rosehedge Dr
Whittier, CA 90606"
After the "Enter" and before the first Comma is the City. I want to pull just the city out of the cell in the next column. Any idea? First on is in Cell C2.
"11493 East Rosehedge Dr
Whittier, CA 90606"
After the "Enter" and before the first Comma is the City. I want to pull just the city out of the cell in the next column. Any idea? First on is in Cell C2.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER