» Counting how many times specific character appears in cell in Microsoft Excel
CATEGORY - Excel Text , Counting
VERSION - All Microsoft Excel Versions
Text in cell A1: Are you going to Disney ? The Character: o in cell A2 The Function: =LEN(A1)-LEN(SUBSTITUTE(A1,A2,"")) Result: 3
Book Store:
Recommended Books:
Excel Tiip
Bashir Mukaddam Posted on: 31-12-1969
This is the tip I was looking for years. Now, it becomes very easy to count characters. Great tip!!!

