For example, you have the following the text in a cell “A1″: I want to check if this word is in the cell in Excel To check if the word “Excel” is in cell A1, use the following formula: =IF(ISNUMBER(SEARCH(“Excel”,A1)),”Yes”,”No”) The result: Yes Not working for you? Remember to replace A1 with the cell that […]

# Category Archives: Functions

## How to count the number of words in a cell in Excel

For example, you have the following the text in a cell “A1″: Count the number of words in this cell To count the number of words in cell A1, use the following formula: =IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,” “,””))+1) The result: 8 Not working for you? Remember to replace A1 with the cell that contains the string of words […]

Posted in Functions
Leave a comment