Thread: counting no. of times a character occurs in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default counting no. of times a character occurs in a cell
Try

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

Mike


"hsg" wrote:

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
Reply With QuoteReply With Quote