Column A has (say) 5 cells.

A1 = R, A2 = R, A3 = O, A4 = R, A5 = O

I need to count the Rs and Os separately

So column B ends up with B1 = 1R, B2 = 2R, B3 = 1O, B4 = 3R, B5 = 2O
or at least B1 = 1, B2 = 2, B3 = 1, B4 = 3, B5 = 2
so i can later say =B1&A1 to merge them into what i need.

thx in advance.