Excel Formula to Filter records that contain a specific text in a sentence | Excel Large functions

Lear how to Filter records that contain a specific text in a sentence in excel | Learn how to search and filter data in Excel.

Breakdown of the Formula:

SEARCH(C2, B5:B15)

This checks if the value in C2 appears within each cell in the range B5:B15.
If found, it returns the starting position of C2 within the text.
If not found, it returns a #VALUE! error.

ISNUMBER(SEARCH(C2, B5:B15))

Converts the SEARCH result into TRUE or FALSE:
If SEARCH returns a number (position of C2), ISNUMBER returns TRUE.
If SEARCH returns #VALUE!, ISNUMBER returns FALSE.
FILTER(B5:C15, ISNUMBER(SEARCH(C2, B5:B15)))

The FILTER function keeps only the rows in B5:C15 where ISNUMBER(SEARCH(...)) is TRUE.
This means only rows where B5:B15 contains C2 will be displayed.

✅ Filter Text in Excel
✅ Excel Filter Function
✅ Search Text in Excel
✅ Excel Formula to Find Text
✅ Filter Data Based on Text
✅ Excel SEARCH Function
✅ Excel FIND Function
✅ Excel TEXT Functions
✅ Excel Advanced Filter

#exceltips #exceltricks #exceltips #exceltutorial #excelformula #exceltipsandtricks