Excel Forum
Similar Content
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...
Prevent Spaces from Being Entered in Text in Excel
Tutorial: How to prevent a user from entering any spaces within text in Excel.  This allows you to ...
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 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.