Selecting cells containing spcific character(s)

[ianwitt]

Hello,

I need to know how to get Excel to select all cells within a specific
column that contain a specific character. In this instance, I need to
select all the cells which contain a comma...

And even better would be if I could get Excel to not just select all
the cells in a specific column containing a comma, but each of the rows
in which those cells reside.

I hope this makes sense and someone can help me.

Thanks.

 

[Ryan.Chowdhury]

Well, this may or may not fit your needs, but consider creating a new
column next to your "text" column that uses the search formula:

=if(isnumber(search(",",[cell reference to the left])),1,0)

Now you'll have a 1 or 0 if there's a comma. Then do an autofilter on
the range and filter for 1. If you select the area, it will only
select the "visible" cells.

Ryan