| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate text strings
It is an array formula. Select the cell with the formula, click in the formula bar then press Ctrl + Shift + Enter -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "ibo4lyf" wrote in message 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
