Does the cell contain the character "-" within the string?

Guest · Dec 3, 2006

Does anyone know how to determine the cell containing the character "-" with
the string? for example
In cell A1, =" - ", which include the character "-", then return true in B1.
Thank for any suggestion
Eric

Guest · Dec 3, 2006

=IF(LEN(SUBSTITUTE(A1,"-",""))=LEN(A1),FALSE,TRUE)

Guest · Dec 3, 2006

Thank you very much
Eric

Gary''s Student said:
=IF(LEN(SUBSTITUTE(A1,"-",""))=LEN(A1),FALSE,TRUE)

JMay · Dec 3, 2006

FYI
Also there's:
=ISNUMBER(FIND("-",A1))

Thank you very much
Eric

Dave Peterson · Dec 3, 2006

A couple more:
=countif(a1,"*-*")>0
=isnumber(search("-",a1))

How to determine char or number?	4	Feb 9, 2010
How to retrieve the value within string?	10	Apr 19, 2010
How to detect characters in cell?	1	Nov 10, 2007
How to determine the value - 02Dec?	3	Dec 2, 2008
How to count the number of occurrence within string?	2	Oct 12, 2008
How to determine the cell contain number only?	1	Jul 2, 2007
How to count the match letter within a string?	7	Aug 22, 2007
How to change color within string?	2	Mar 18, 2010

Does the cell contain the character "-" within the string?

Guest

Guest

Guest

JMay

Dave Peterson

Ask a Question

Similar Threads