Thread: Count the number of appearance within a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lucy Lucy is offline
external usenet poster
  
Posts: 37
Default Count the number of appearance within a cell
In cell A1, I put text "Apple"

How can I count the number of appearance of letter "p" within one cell?

I would like the answer come out as numeric "2"

Thanks.
Reply With QuoteReply With Quote