| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting SubStrings and thier starting positions within Main Strin
What is the easiest way to count the number of occurences of a substring
within a string AND the starting position of each substring? For Example: String = "dog 123 cat 452 if 6754 dog" SubString = "dog" Occurences of SubString = 2 Starting Position of SubString = 1 and 26 Thanks EM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| array formulas counting substrings across rows | Excel Worksheet Functions | |||
| counting starting with a number other than 1 | Excel Discussion (Misc queries) | |||
| Counting Starting Digits | Excel Worksheet Functions | |||
| Counting Positions | Excel Programming | |||
| counting cells in a column based on thier color | Excel Programming | |||
Threaded Mode
