HELP WITH FORMULA

[Guest]

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

 

[Guest]

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

 

[Guest]

You're the best ! Thank you.

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