This example describes how to count the number of words in a cell.
1a. The TRIM function returns a string with extra spaces, starting spaces and ending spaces removed.
1b. To get the length of the string with normal spaces, we combine the LEN and TRIM function.
2a. The SUBSTITUTE function replaces existing text with
new text in a text string. We use the SUBSTITUTE function to get the
string without spaces.
2b. To get the length of the string without spaces, we combine the LEN and SUBSTITUTE function.
3. Now comes the simple trick. To get the number of words, we
subtract the length of the string without spaces (10) from the length of
the string with normal spaces (12) and add 1.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment