» Count the number of words in a cell in Microsoft Excel
CATEGORY - Excel Text , Excel Formula
VERSION - All Microsoft Excel Versions
Use the following function:
=IF(LEN(A1)=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+1)
The result: 5
Book Store:
Recommended Books:
- The Interpretation of Financial Statements
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Special Edition Using Microsoft Access 2002
Enter remarks for class
Patrick Ho
Great help in writing remarks for class that has requirement of words limit in the report book.
Thanks
Big Mac
BEST FORMULA EVER!!!
Worked like a charm!
Thanks
Count Number of Specific Word
faxy
How can I find: how many disneyland word contains one specific cell?
For example A1 cell : disneyland disneyland
Answer: 2
Tnx
