| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the number of occurrence within string?
Does anyone have any suggestions on how to count the number of occurrence
within string? For example, aa11bb5c in cell A1, and "a" in cell B1, I would like to count the number of occurrence for the char "a" in cell B1 within string "aa11bb5c" in cell A1, and return the number of occurrence 2 in cell c1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find SECOND occurrence in a string? | Excel Worksheet Functions | |||
| Most common occurrence of a string | Excel Worksheet Functions | |||
| count number of letters in a string | Excel Worksheet Functions | |||
| How to count the number of times a string appears in a column? | Excel Worksheet Functions | |||
| count number of occurences within a string | Excel Worksheet Functions | |||
Threaded Mode
