Thread: Count the number of appearance within a cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Count the number of appearance within a cell
=SUM(LEN(A1)-LEN(SUBSTITUTE(A1,{"p","P"},"")))


"Lucy" wrote:

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