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

[Guest]

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

 

[Jason Morin]

Select the column, press Ctrl+H, key in

,*

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

HTH
Jason
Atlanta, GA

 

[Gord Dibben]

Mini

Data>Text to Columns>Delimited by comma>Next select the "state" column and "do
not import".

Or if you want to preserve the data in the original column, in an adjacent
column enter

=LEFT(A2,IF(ISERROR(FIND(",",A2,1)),LEN(A2),FIND(",",A2,1)-1))

Copy down.


Gord Dibben Excel MVP