Thread: Counting a Specific Character
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Counting a Specific Character
=LEN(A1)-LEN(SUBSTITUTE(A1,"+",""))

--
Gary''s Student - gsnu200849


"FARAZ QURESHI" wrote:

Any suggestion/formula to count the number of times the character "+" is
present in $A$1?

Thanx
Reply With QuoteReply With Quote