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

[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

 

[Dave Peterson]

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

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