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

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
.

Mini

DataText to ColumnsDelimited by commaNext 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

On Wed, 26 Jan 2005 11:23:02 -0800, "Minivann"
wrote:

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