Hello. I have a large sheet with a cell that has the address in the format (City, ST), for example:
in A1: Philadelphia, PA
in A2: New York, NY
I need to be able to separate this into two cell, with city in one cell and state in the other.
1) For the the state, I know that I can do right(a1,2) and this works;
2) Can you separate the city, which would be to the left of the comma? I am struggling since the city in each of the cells are different lengths.
I appreciate your guidance!
Thank you!!
Bookmarks