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

M

Minivann

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
 
J

Jason Morin

Select the column, press Ctrl+H, key in

,*

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

HTH
Jason
Atlanta, GA
 
G

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
 
Top