Selecting cells containing spcific character(s)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ianwitt - 24 Jul 2006 15:29 GMT

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.

Signature

ianwitt

Reply to this Message

Ryan.Chowdhury@gmail.com - 24 Jul 2006 16:26 GMT

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

> Hello,
>
[quoted text clipped - 15 lines]
> ianwitt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36697
> View this thread: http://www.excelforum.com/showthread.php?threadid=564300

Reply to this Message