» Counting the Number of Times a Substring Appears Within a String
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
Counting the number of times each of the substrings listed in column B appears within the corresponding string in column A.
Solution:
Use the LEN and SUBSTITUTE functions as shown in the following formula:
=(LEN(A2)-LEN(SUBSTITUTE(A2,B2,"")))/LEN(B2)
Book Store:
Recommended Books:
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Microsoft Outlook 2002 for Dummies
- Special Edition Using Microsoft Excel 2002
- Financial Risk Manager Handbook, Second Edition
- Guide to Financial Reporting and Analysis
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
