## Count text that occurs multiple times in excel cell

**Question:** How do I count how many times a text string occurs in a cell in excel?

**Answer:**

**Formula in B5:**

Recommended articles

Count text strings in formulas (vba)

Rahul Jadhav asks: I have many excel files with multiple sheets and each excel sheet has many formula which are […]

Substitute multiple text strings (vba)

The user defined function demonstrated below replaces multiple old text strings with new text strings in a cell. The custom […]

Separate numbers from a text string

Chirag asks: I want to separate numbers from following text: Abc123bx45 as a result 123 and 45 should be in […]

### Functions in this article:

**Len(**text**)**

Returns the number of characters in a text string

**Substitute(**text, old_text, new_text, [instance_num])

Replaces existing text with new text in a text string

*This blog article is one out of three articles on the same subject.*

Count number of times a string exist in multiple cells using excel formula

Question: How do I find the number of occurances a word exists in a range of cells? It does not […]

Count occurences of a specific text string in a column in excel

Question: How do I count the number of times a text string exists in a column? Answer: Array formula in […]

Count number of times a string exist in multiple cells using excel formula

Question: How do I find the number of occurances a word exists in a range of cells? It does not […]Count occurences of a specific text string in a column in excel

Question: How do I count the number of times a text string exists in a column? Answer: Array formula in […]### 11 Responses to “Count text that occurs multiple times in excel cell”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

Thank you my new friend, I needed that. Nice idea to count the characters with and without the term and then to divide by the number of characters in the term.

Justin,

Thank you

Read more:

Count number of times a string exist in multiple cells using excel formula

Count multiple text strings in a cell range

What formula should I use to see how many times a phrase occurs within multiple cells?

Lee,

Count number of times a string exist in multiple cells

can we just print the count of every string(name) in a particular column in front of its name, in a normal table(not pivot table)

and display that in a diff sheet.

How can I do this for a cell that is on a different tab than my formula?

Change cell reference B3 in this formula:

=(LEN(B1)-LEN(SUBSTITUTE(B1, B3, "")))/LEN(B3)

Example:

=(LEN(B1)-LEN(SUBSTITUTE(B1, Sheet3!A1, "")))/LEN(Sheet3!A1)

I know that the substitute function does not support wildcards, so my question is:

Is there a way to count multiple times something like: "??.??.???? ??:??:??"

=(LEN(B1)-LEN(SUBSTITUTE(B1, "??.??.???? ??:??:??", "")))/LEN(B3)

Even if it is not using the substitute function is ok for my purposes.

PS. I cannot install any additional packages as for example REGEX.

Javier,

You don't need to install additional packages.

https://www.get-digital-help.com/2017/05/24/count-matching-strings-using-regular-expressions/

How to search multiple strings at a time in a cell.

For example: I want to see if Inc or Inc. or inc. is present in a cell

Depti,

I believe you are looking for this post:

https://www.get-digital-help.com/2012/03/28/search-for-a-text-string-and-return-multiple-adjacent-values/#multiple