Forum Discussion
Formula in excel
Can somebody help me with a formula for auto replacing 1 as E, 2 as J, 3 as O, 4 as T , 5 as Y , 6 as V, 7 as Q, 8 as L, 9 as G, 10 as B.
so if the number is 1070 it should display as EBQB
if it is 1278 it should be EJQL
or
or VBA (see the file)
Hope I could help you with these information / link / file.
I know I don't know anything (Socrates)
nik_11189 In case you have Excel for MS365 or Excel2021, have a look at the attached file.
