» Counting the Number of Times a Substring Appears Within a String
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
Problem: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:
- The Fall of Advertising and the Rise of PR
- The New Financial Order: Risk in the Twenty-First Century
- Microsoft Office XP Step-By-Step (With CD-ROM)
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
No comments have been submitted.
