I tried to count all the letters that appear in M16 - DH16 one by one vertically since i cant do it aautomatically.
Starting from Cell m16 - m29 I use the Txt2score formula in Vba macro to convert to number and then display the result in cell m30 and m31.
I' tried = Txt2Score (M16: M29) But it does not work. it can only be used for one cell ex : txt2score(m16) .
Is there another formula to calculate it properly? its ok vba formula.
cell m31 for single digit only now :
Please Login or Register to view this content.
Bookmarks