Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I count the number of times a particular charcter ("." say)
How do I count the number of times a particular charcter ("." say) appears in
a cell. For example, ABC.1.21.31.2 should retun 4. Is there a formula? |
#2
|
|||
|
|||
=LEN(A1)-LEN(SUBSTITUTE(A1,".",""))
-- HTH RP (remove nothere from the email address if mailing direct) "RH" wrote in message ... How do I count the number of times a particular charcter ("." say) appears in a cell. For example, ABC.1.21.31.2 should retun 4. Is there a formula? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I count the number of times a particular charcter ("."
"Bob Phillips" wrote: =LEN(A1)-LEN(SUBSTITUTE(A1,".","")) -- HTH RP (remove nothere from the email address if mailing direct) "RH" wrote in message ... How do I count the number of times a particular charcter ("." say) appears in a cell. For example, ABC.1.21.31.2 should retun 4. Is there a formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) |