Excel Forum
Similar Content
Formula to Count Occurrences of a Word in a Cell or Range in Excel
Tutorial: Formula to count how many times a word appears in a single cell or an entire range in Exce...
Count The Number of Words in a Cell or Range of Cells in Excel - With User-Specified Delimiter / Separator - UDF
Macro: UDF to count the number of words in a cell or range with a user-specified delimiter. ...
List Slicer Selections in a Cell in Excel
Tutorial: How to list all slicer selections for a Pivot Table in a single cell in Excel. This allow...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 492: Count Matches in Single Cell


See how to use SUMPRODUCT, MID, SUBSTITUTE, and array constant in a formula to count the number of matches of 9 values entered into a single cell. See how to use SUBSTITUTE to remove spaces.





Got a Question? Ask it Here in the Forum.