Main Profile

At A Glance

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
Length: 08:54

Contact

Questions about Excel Magic Trick 288: Count Character or Nums. In Text String

Want more info about Excel Magic Trick 288: Count Character or Nums. In Text String? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question