Thread: checking for a string & No.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default checking for a string & No.
=LEN(A2)-LEN(SUBSTITUTE(A2,"A",""))
--
David Biddulph

"Christopher Naveen" wrote in
message ...

... Also pls tell me how can we find that how
many A's i have in a cell,

Ex :

AAAABBN
AHHH
AQREE
AA
....


Reply With QuoteReply With Quote