find specific character in a cell

**LiamF** · 08-09-2007, 07:08 AM

hi, I have a range of cells, some have the character in and some don't. I need a quick way of finding which cells have the character or not, so I can sort them. Is there a simple formula for this?

thanks
Liam

**Ron Coderre** · 08-09-2007, 07:24 AM

With
A1: (any value)

This formula returns 1 if A1 contains the letter "A":
B1: =COUNTIF(A1,"A")

Note: COUNTIF is NOT case-sensitive. That formula will return 1 for both of these:
A1: 123a5
A1: 123A5

If you need an exact case-sensitive match, then this formula returns TRUE if A1 contains ""A":
B1: =ISNUMBER(FIND("A",A1))

Does that help?