How do I evaluate whether a character is present in a cell?
Actually, you don't even need to use IF:
=LEN(A1)LEN(SUBSTITUTE(A1,"/",""))
will return TRUE if A1 contains / or FALSE if it doesn't.
Hope this helps,
Hutch
"Crash" wrote:
I am hoping I can evaluate whether a specific character is present in the
text of a cell using an If function.
For example if I test for a forward-slash in a cell containing the text
abc/def I want a TRUE result but in a cell containing the text abcdef I want
a FALSE result.
Is this possible?
|