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

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

On Wed, 26 Jan 2005 11:23:02 -0800, "Minivann"
<Minivann@discussions.microsoft.com> 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