| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate text strings
I am trying to calculate a series of text occurences within a spread
sheet. I cannot seem to figure out a formula to calculate this. I found this: =SUM(LEN(A8:A13)-LEN(SUBSTITUTE(A8:A13,"apple","")))/LEN("apple") But this only works for mac. I would like the same result, but on a PC. I throw myself to the mercy of Google Groups! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
| Looking for Text strings | Excel Worksheet Functions | |||
| VLookup and text strings | Excel Discussion (Misc queries) | |||
| Counting Text Strings | Excel Worksheet Functions | |||
| Text Strings Conversion | Excel Worksheet Functions | |||
Threaded Mode
