» 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:
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Microsoft Excel 2002 Simply Visual
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Definitive Guide to Excel VBA
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Windows XP Pocket Reference
No comments have been submitted.
