Need Help with Formula

Copper Contributor

I am trying to write a formula that take a column of strings and lets me know if a character is present. For example, Cell A1 contains the character “6”, and would like for that statement to be true, if not then false.  I have tried using the search function but it seems i may have a misunderstanding. 

 

1 Reply

@flexmon Try this:

=ISNUMBER(SEARCH(6,A1)) or

=ISNUMBER(SEARCH("6",A1))

 

both will work.