36. Excel Tips - How many times does a letter appear in a cell ?
Suppose you have a big string like: "XXX0000sdsds000000000" and you want to know how many times "0" appears.
Here's our data:
The formula we use is:
=LEN(B3)-LEN(SUBSTITUTE(B3,"0",""))
Download Example Sheet to practise getting finding out how many times a letter appears in a string
Training Video - How many times does a letter appear in a cell ?
| Attachment | Size |
|---|---|
| How-many-times-does-a-letter-appear-in-a-cell.xls | 17 KB |
»
- Nick's blog
- Login or register to post comments
- 13008 reads
my issue
is nice to know how many time does a letter appaear in a cell,but now come's my question.. how many time does a number appaear in a column ? .EX: if i have 1 column A1,A100 full whit numbers end some of them reapet ,i whant to know how many time my number reapeat.Tks in advance end sorry for my bad engl. :)
COUNTIF
use the function COUNTIF