» 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:
- Understanding Financial Statements
- Financial Risk Manager Handbook, Second Edition
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Positioning: The Battle for Your Mind
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
No comments have been submitted.
