Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I'm trying to count the number of times a character appears within a string. I thought there was a function that could do this (i.e. one line of code), but can't seem to find it. For example, if I have a cell that contains "27,45,8,19,13" and want to count the commas, I'm looking for something like this: Num = CountChars("," , Cell.Value) where CountChars is the mystery function that I'm seeking. I can get the result I want with the Search function and a Do...Loop, but if there was a function it would make it much cleaner. Thanks. Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting No of character in a string | Excel Worksheet Functions | |||
Counting instances in string | Excel Discussion (Misc queries) | |||
counting x instances of a string across columns... | Excel Worksheet Functions | |||
counting the number of instances of a string within another string | Excel Worksheet Functions | |||
Counting specific character in text string | Excel Worksheet Functions |