Thread: counting no. of times a character occurs in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hsg hsg is offline
external usenet poster
  
Posts: 40
Default counting no. of times a character occurs in a cell
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