| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
One way:
=LEN(A1)-LEN(SUBSTITUTE(A1," ","")) In article , "gbeard" wrote: Is it possible to count how many times a space occurs in a cell? If I could count the words in a cell...that would work as well. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding occurrences for date range | Excel Discussion (Misc queries) | |||
| adding occurrences for date range | Excel Discussion (Misc queries) | |||
| Counting occurrences of multiple conditions | Excel Discussion (Misc queries) | |||
| Number of Occurrences between Specidied Date | Excel Worksheet Functions | |||
| lookup multiple occurrences of a value excel | Excel Worksheet Functions | |||
Threaded Mode
