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



Download file:
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

Nguồn: https://samurai-weapons.net/

Xem thêm bài viết khác: https://samurai-weapons.net/category/cong-nghe/

4 thoughts on “Excel Magic Trick 288: Count Character or Nums. In Text String

  1. Respected sir,
    Please send to me magic tric 288 file download link
    You are a great teacher.
    i proud that i am attach you.

  2. Dear rsbeena ,

    I do not know how to use the Subtotal feature to go horizontal. It sounds like then used the grouping feature to get the "plus sign" to appear horizontally, but this is a manual proccess.

    I do not know a fast way to do that.

    –excelisfun

Leave a Reply

Your email address will not be published. Required fields are marked *