Aug 31 2022 12:21 AM
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
Aug 31 2022 12:33 AM
@nik_11189 In case you have Excel for MS365 or Excel2021, have a look at the attached file.
Aug 31 2022 12:56 AM
or
or VBA (see the file)
Hope I could help you with these information / link / file.
I know I don't know anything (Socrates)