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
counting no. of times a character occurs in a cell 3
Help Needed With Count 2
Count Num of Unique items in col ? 11
count text occurance in range 3
Count Instances of Text in String Q 6
Count the times a value appears in a column based on another value 6
number times a value appears in a column beside it chronological 3

Top