Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm sure there is an easy way to do this; I just haven't had to do it before
so I'm not sure what the most elegant solution is. I have a column of values, and within each cell, there are an unknown number of commas (e.g. "323,76,12,43"). I need to identify (for each cell, in the next column over) how many commas are present. The basic instr or match type functions (I think) only provide the first match location, not a total number of matches. Maybe something like the opposite of REPT, only something that ignores all the other text and just gives the count of the target string that is already repeated in the cell. Any suggestions on a preferred approach? Thank you, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting the appearance of a String in a Row | Excel Worksheet Functions | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
Counting number of time a character appears in a string | Excel Worksheet Functions | |||
Countif function for instances of text string contained | Excel Worksheet Functions | |||
Countif function for instances of text string contained | Excel Worksheet Functions |