Excel Tip – Counting characters in a text

There is a formula in Excel which lets us count how many times a certain character occurs in a text string irrespective of whether it is upper or lower case. I.e. The following formula will count the number of “B”s, both upper and lower case, in the text contained in cell A1:


Share this tip on