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


"Soth" wrote:

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