Excel Forum
Similar Content
Count Cells that Contain Specific Text in Excel
Tutorial: Simple formula to count the occurrence of any text value in a cell or range of cells in E...
Filter Results in Excel to Show Only Those that End With Specified Text or Words - AutoFilter
Macro: This free Excel macro filters data to display results that end with certain words, text, o...
Simple Excel Function to Extract a Word or Text from a Cell
Tutorial: Excel function that makes it easy to extract a word or text from a cell in Excel. This is ...
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 288: Count Character or Nums. In Text String


See how to count the number of characters or numbers in a text string with a formula that is case sensitive. For example 1) there are three letter a in string: a567taAarr or 2) there is one number five a in the text string: a567taAarr.
See the functions SUMPRODUCT, MID, ROW, INDIRECT, LEN, CODE and TEXT in one array formula.
This video is in response to this video:
Excel Magic Trick #223 Count Single Character In Text String





Got a Question? Ask it Here in the Forum.