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
Word macro that can call cells out of Excel for a find and replace 0
Converting a number into a cell reference 2
Counting one Character as a String 1

Top