Summary
In this video we filter based on a partial text string.
Tab in example file: Partial match
In this example we introduce the SEARCH and ISNUMBER functions.
SEARCH – Returns the character position at which a text string is found within another text string.
The syntax for SEARCH is:
=SEARCH(find_text, within_text, [start_num])- find_text – The text to search for.
- within_text – The text to search within.
- [start_num] is not used in this example
If the string is not found, the function returns #VALUE!
SEARCH is case insensitive; use FIND for a case-sensitive search.
ISNUMBER – Checks if a value is a number and returns TRUE or FALSE.
The syntax for ISNUMBER is:
=ISNUMBER(value)- value – The value to test