Hello , 

Do you want to classify your data using searching for specific text in cell

here is the way:

To check if a cell contains specific text, you can use the SEARCH function together with the ISNUMBER function.

=ISNUMBER(SEARCH("School"|K2))

Untitled

More clarification:

The SEARCH function returns the position of the search string when found and the #VALUE! error if not. We use this fact to test when the search string is found by using the ISNUMBER function to “catch” valid numeric positions.

ISNUMBER returns TRUE for numbers and FALSE for anything else. So, if SEARCH finds the substring, it returns the position as a number, and ISNUMBER returns TRUE. If SEARCH doesn’t find the substring, it returns a #VALUE! error, which causes the ISNUMBER to return FALSE.

Advertisements