Thread: How do I evaluate whether a character is present in a cell?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How do I evaluate whether a character is present in a cell?
Another one...

=COUNTIF(A1,"*/*")0

--
Biff
Microsoft Excel MVP


"Crash" wrote in message
...
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?


Reply With QuoteReply With Quote