View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How do I evaluate whether a character is present in a cell?

Use FIND() or SEARCH().

=ISNUMBER(FIND("/",A1))

=IF(ISNUMBER(FIND("/",A1)),"true statement","false statement")

If this post helps click Yes
---------------
Jacob Skaria


"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?