Seperating values

O

One-Leg

Hello,

I have a list of about 5000 cities with their associated state (seperated
with a coma). The list of cities are in colomn "A".

How can I automatically have the city copied into column "B" and the state
in column "C" without having to use the TEXT TO COLUMN option?

For the state, I can use "=RIGHT(A2,2)" so I'm ok with that. It's how do I
do the same for the city as every cities have different amount of characters
but are all located in front of a coma.

Thanks!!!
 
J

John C

Assuming everything is in format of: city name, ST
State, as you said: =RIGHT(A2,2)
City would be: =LEFT(A2,LEN(A2)-4)
 
O

One-Leg

Thank you!!! It worked like a charm...

John C said:
Assuming everything is in format of: city name, ST
State, as you said: =RIGHT(A2,2)
City would be: =LEFT(A2,LEN(A2)-4)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top