Break One Column A (City, State) into 2 columns A City, B State

  • Thread starter Thread starter d
  • Start date Start date
D

d

I have a spreadsheet that has City, State in one column and need to break
that up into 2 columns (one for city and one for state)

What is the easiest way to do that?

Thank you.

Regards,
Diane
 
If the cities and states are always separated by a comma, you could:

Select the column
Data|Text to columns|delimited by comma
 
Back
Top