Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting number of time a character appears in a string
Does anyone know a way to automatically count how many times a certain
character counts in a text string? |
#2
|
|||
|
|||
Counting number of time a character appears in a string
I meant to say:
Does anyone know a way to automatically count how many times a certain character appears in a text string? (i.e. "w" appears 3 times in the string above) "Henrik" wrote: Does anyone know a way to automatically count how many times a certain character counts in a text string? |
#3
|
|||
|
|||
Counting number of time a character appears in a string
Henrik wrote...
Does anyone know a way to automatically count how many times a certain character counts in a text string? To count the number of Xs in s, try =LEN(s)-LEN(SUBSTITUTE(s,"X","")) |
#4
|
|||
|
|||
Counting number of time a character appears in a string
=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))
will count the occurrence of a in cell A1, if you have a range with strings use =SUMPRODUCT((LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"a","")))) -- Regards, Peo Sjoblom "Henrik" wrote in message ... Does anyone know a way to automatically count how many times a certain character counts in a text string? |
#5
|
|||
|
|||
Counting number of time a character appears in a string
FYI, I figured it out:
=LEN(cell_ref)-LEN(SUBSTITUTE(cell_ref,"character","")) "Henrik" wrote: I meant to say: Does anyone know a way to automatically count how many times a certain character appears in a text string? (i.e. "w" appears 3 times in the string above) "Henrik" wrote: Does anyone know a way to automatically count how many times a certain character counts in a text string? |
#6
|
|||
|
|||
Counting number of time a character appears in a string
On Thu, 20 Oct 2005 14:25:02 -0700, Henrik
wrote: Does anyone know a way to automatically count how many times a certain character counts in a text string? To count the number of appearances of a character in a text string: =LEN(A1)-LEN(SUBSTITUTE(A1,char_to_count,"")) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting number string to number with decimal | Excel Worksheet Functions | |||
Insert a Seperator into a number string. | Excel Discussion (Misc queries) | |||
last number array from string | Excel Worksheet Functions | |||
Counting the number of times a word appears in a worksheet | Excel Worksheet Functions | |||
how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) |