Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Count Number of Words in Excel

This chapter shows how to count the number of words in a cell.

1a. The TRIM function returns a string with leading spaces, extra spaces and trailing 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.

Also See:   How to extract domain name from URL in Excel

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.

Also See:   Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *