find

G

Guest

Hello,

Is there a formula I could use to tell me if a cell
contains the Letter "C" somewhere within the text. I am
familiar with the
=Left(cell,#)
=Mid(cell,#,#)
=right(cell,#)

But I do not know which order the C will show up at so
these will not work.

Thanks
 
F

Frank Kabel

Hi
one way:
=ISNUMBER(FIND("C",A1))
if case sensivity is required.

If not you could use
=ISNUMBER(SEARCH("C",A1))
or
=COUNTIF(A1,"*C*")>0
 
C

Chip Pearson

Try a formula like the following:

=IF(ISERROR(SEARCH( "C",A1,1)),"C not found","C found")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top