close
Try something like this:
For text in A1
B1: =SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),quot;Aquot;,quot;quot;)))
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Proquot;JavyDquot; wrote:
gt; May I add, I've been using Countif, but lets say the cell has a Text like so
gt; - ART GOES TO CAMP, it would say theres only one A, theres actually 2.
gt;
gt; quot;JavyDquot; wrote:
gt;
gt; gt; How do you do this, tried to figure out, and I can't I need to count the
gt; gt; number of A's in a cell, or any other letter that I define. Thanks.
全站熱搜
留言列表
