counting no. of times a character occurs in a cell

H

hsg

Can a function tell the number of times a particular character is occuring in
a text string in a particular cell?

A1 contains ABCD,ACDT,AKBL,BCDF,PIZQ

I would like to count no. of "commas" appearing (",") in this cell.

hellp appreciated, thanks

hsg
 

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
count no. of commas (,) in a string in a cell 3
count no. of times a character occurs in a cell 2
Count the times a specific character appears in a cell 3
how to count if cell "contains" a word 22
Finding/counting a given character within a cell 10
Counting number of times name occurs between two dates 2
counting the number of times a word appears 5

Top