ExcelBanter - HELP WITH FORMULA

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HELP WITH FORMULA (https://www.excelbanter.com/excel-worksheet-functions/88688-help-formula.html)

Soth

HELP WITH FORMULA

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

Elkar

HELP WITH FORMULA

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

Soth

HELP WITH FORMULA

You're the best ! Thank you.

"Elkar" wrote:

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

All times are GMT +1. The time now is 03:05 AM.