In a column of text data, how do I delete random cells that have .

for example, in the column of city, I have some cells with data in this
format:"city,state" and i just want the city.
Do I have to go manually and delete or is there a quicker way?

thank you