Select the column, press Ctrl+H, key in

,*

into "Find What" and click "Replace All".

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.