Hello,

I'm wondering if anyone has a formula to identify and split a string of characters in a column Ie:
A
1M00
4N50
6M00
1A00
1J10
2K84
4H71

I would need it to separate the first digit from the second character and count how many of each there are. There could potentially be 5-1000 cells to identify within the column.
Thanks for any assistance in this.