Excel Forum
Similar Content
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Count the Number of Cells that Contain Specific Text in Excel
Tutorial: How to count the number of cells that contain specific text within a spreadsheet in Excel....
Count the Number of Cells that Start or End with Specific Text in Excel
Tutorial: How to count cells that match text at the start or the end of a string in Excel. If you w...



Excel Magic Trick 321: Match Text Substrings


See how to Match All Text Substrings with an array formula that uses the AND ISNUMBER and SEARCH functions.





Got a Question? Ask it Here in the Forum.