Excel Forum



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.