| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting specific character in text string
Within a cell, I need to count the number of times a given character (dash)
occurs. I suspect that I need to use a recursive FIND, but I don't know how to do it. Can anyone help? Thanks, Bob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting specific character in text string
One way:
=LEN(A1)-LEN(SUBSTITUTE(A1,"-","")) In article , Bob wrote: Within a cell, I need to count the number of times a given character (dash) occurs. I suspect that I need to use a recursive FIND, but I don't know how to do it. Can anyone help? Thanks, Bob |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting specific character in text string
=LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))
"Bob" wrote: Within a cell, I need to count the number of times a given character (dash) occurs. I suspect that I need to use a recursive FIND, but I don't know how to do it. Can anyone help? Thanks, Bob |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting specific character in text string
Thanks!!!
"Teethless mama" wrote: =LEN(A1)-LEN(SUBSTITUTE(A1,"-","")) "Bob" wrote: Within a cell, I need to count the number of times a given character (dash) occurs. I suspect that I need to use a recursive FIND, but I don't know how to do it. Can anyone help? Thanks, Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Finding specific text in string - Part II | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Setting character attributes in a text string | Excel Worksheet Functions | |||
| Counting specific text in a cell | Excel Worksheet Functions | |||
Linear Mode
