Forum Discussion
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
Another approach would be
= REDUCE(string, letters,
LAMBDA(str, chr,
SUBSTITUTE(str, chr, XMATCH(chr, letters))
)
)where 'letters' is the array of letters you are replacing in 'string'.