View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default Counting a Specific Character

Wow man! XClent!

As I had stated earlier a Master like you can't be a Student.

"Gary''s Student" wrote:

=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