I would like to count how many "1", "x" and "2" I have within the string below:
cell a1, string "1x21x21x21x21xx",
cell b1, 5 ( number of "1")
cell c1, 6 ( number of "x")
cell d1, 4 ( number of "2")

Bear in mind that string could change in size, with more or less characters
on it and column A is full of them, around 5000 rows.
Is there any formula or combination of formulas that allow me to calcualte
this?
Thanks in advance.