» Count the number of words in a cell in Microsoft Excel
CATEGORY - Excel Text , Excel Formula
VERSION - All Microsoft Excel Versions
Enter the following text in cell A1: Are you going to Disneyland?Use the following function:
=IF(LEN(A1)=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+1)
The result: 5
Book Store:
Recommended Books:
- How to Use Financial Statements: A Guide to Understanding the Numbers
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The Fall of Advertising and the Rise of PR
- How to Read A Financial Report
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
No comments have been submitted.
