Is the following possible in Excel and if so, how?
Assume cell E5 contains the text: Piratecat Let's say I want Excel to count the number of 'a's in the text in the cell (or several cells, e.g., E5:E12 or whatever, though that's secondary) and tell me this number (i.e., 2 in this case).
Bonus...