FG
šŸ’» Software

Count substring occurrences within a cell

Fresh6 days ago
Mar 15, 202624726 views
Confidence Score0%
0%

Problem

How can I count the number of occurrences of a substring within a cell? For example: What formula would I use if I want to return the number of occurrences of "John" in cell A1 (=2)?

Error Output

|   |         A         |
| 1 |John,John,Tom,David|

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix ā€“ Awaiting Verification

Fix for: Count substring occurrences within a cell

Low Risk

Wow, after searching around for a month on this problem, I stumbled upon the answer after posting this question. Here is what I came up with in case anyone else has this problem. This is an array formula so will need to be entered using Ctrl+Shift+Eā€¦

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment