Forum Discussion

Copper Contributor

Apr 01, 2023

Need Help with Formula

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,...

excel

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Apr 01, 2023

flexmon Try this:

=ISNUMBER(SEARCH(6,A1)) or

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

both will work.