» 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:
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Marketing Management
- How to Pay Zero Taxes (Annual)
- Analysis of Financial Statements
- Business Plans Kit for Dummies (With CD-ROM)
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
No comments have been submitted.
