Forum Discussion
lindagrimm8251
Apr 09, 2025Copper Contributor
Need help with excel formula to convert groups of letters to numbers.
I need to be able to convert groups of letters to numbers. F = 1 R = 2 E = 3 D = 4 A = 5 J = 6 V = 7 O = 8 N = 9 ie FDAJ = 1456 VJAR = 7652 Any help would be greatly appreciated
HansVogelaar
Apr 10, 2025MVP
With FDAJ in A1:
=CONCAT(SEARCH(MID(A1, SEQUENCE(LEN(A1)), 1), "FREDAJVON"))