|  

» Counting the Number of Times a Substring Appears Within a String

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)


Rate This Tip
12 34 5
Rating: 4.00     Views: 11519
No comments have been submitted.
Name
Comment Title
Comments