HELP WITH FORMULA

S

Soth

Hi,

How do I split the state and the city into 2 column?

ie

column A ...............like to see in column B as State............Column
C as City
AZ-CHANDLER AZ
Chandler


Thanks
Soth
 
E

Elkar

Assuming all of your data follows the same format (State Dash City) then use
these formulas:

In Column B:
=LEFT(A1,2)

In Column C:
=RIGHT(A1,LEN(A1)-3)

HTH,
Elkar
 
S

Soth

You're the best ! Thank you.

Elkar said:
Assuming all of your data follows the same format (State Dash City) then use
these formulas:

In Column B:
=LEFT(A1,2)

In Column C:
=RIGHT(A1,LEN(A1)-3)

HTH,
Elkar
Click to expand...
 
Top