Count the times a specific character appears in a cell

H

hl

I am trying to count the number of times a specific character appears
in a cell (or range of cells). Anyone know how to do this?

Example: The cell contains "Fruit/Meat/Fish" and I would like a
formula counting the number of times "/" appears (returning the value
2).

Brgds,
Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting the number of times a character occurs in a cell 1
Help Needed With Count 4
Function in Excel to count and list number of entries of text valuesin a row. 2
How to count the numbers in a Word document? 0
count text occurance in range 3
Calculate the median value before a specified list 0
Count Num of Unique items in col ? 11
counting no. of times a character occurs in a cell 3

Top