Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count # of A's in a Cell
Like a charm, I feel so stupid, you made that look so easy, thanks again,
youre the best "Ron Coderre" wrote: Adjustment: The formula I previously posted can be used to count occurrences of text in a range. Since you're only testing one cell, use this B1: =LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"A","")) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "JavyD" wrote: May I add, I've been using Countif, but lets say the cell has a Text like so - ART GOES TO CAMP, it would say theres only one A, theres actually 2. "JavyD" wrote: How do you do this, tried to figure out, and I can't I need to count the number of A's in a cell, or any other letter that I define. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Count | New Users to Excel | |||
Count on cell for each time it is changed | Excel Discussion (Misc queries) | |||
I need to keep a count of the times a cell is changed | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) |