If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
# of occurrences
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. Thanks, -- Gary Beard |
#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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Counting occurrences of multiple conditions | Jvanderv1 | General Discussion | 2 | April 6th, 2005 01:07 AM |
Counting Number of Occurrences in a Duplicate Query | BLG | Running & Setting Up Queries | 1 | January 17th, 2005 05:09 PM |
Counting occurrences of |
Frank Kabel | Worksheet Functions | 0 | February 6th, 2004 11:25 PM |