Replacing number digits with letter code

[marcd]

I want to replace number with coded letter.
0=Q
1=L
2=T
3=M
4=F
5=V
6=S
7=R
8=K
9=G

I may enter a 5 digits to 12 digits number and needs to get the according letters.

 

[jasonb75]

With your number in A1, try this formula in B1, fill down as needed.

=CONCAT(MID("QLTMFVSRKG",1+MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),1))

You might need to confirm it as a legacy array with Ctrl Shift Enter.

 

[kweaver]

Welcome to Mr. Excel.
I created helper columns from column E and filled across:

Book2
	A	B	C	D	E
1	Codes		Number	Convert
2	0	Q	2310	TMLQ	T
3	1	L
4	2	T
5	3	M
6	4	F
7	5	V
8	6	S
9	7	R
10	8	K
11	9	G
Sheet1

Cell Formulas
Range	Formula
D2	D2	=CONCAT(E2:P2)
E2	E2	=IFERROR(INDEX($B$2:$B$11,1+MID($C2,COLUMN()-4,1),1),"")

 

[Peter_SSs]

Welcome to the MrExcel board!

If you have the SEQUENCE function in your Excel 365, you could also try this non-volatile version.

20 08 23.xlsm
	A	B
1	56982	VSGKT
2	236598012001	TMSVGKQLTQQL
Encode Number

Cell Formulas
Range	Formula
B1:B2	B1	=CONCAT(MID("QLTMFVSRKG",MID(A1,SEQUENCE(LEN(A1)),1)+1,1))

 

[marcd]

Thank you very much, it's working lovely and helps me a lot.

 

[Peter_SSs]

You're welcome. Glad we could help.