Convert Interger number to column Alphabet

[rizmomin]

Hello:

I have M106 = 4

I need a simple formula to convert that into column Alphabet + 1

So 4 will be Column E (A,B,C,D and 4th will be D+1= E)

Let me Know if you have any questions.
Thanks.



Riz

[Kaper]

use:
=CHAR(M106+65)

[AlKey]

Maybe this

=CHAR(A1+64)

	A	B
1	1	A
2	2	B
3	3	C
4	4	D
5	5	E
6	6	F
7	7	G
8	8	H
9	9	I
10	10	J
11	11	K
12	12	L
13	13	M
14	14	N
15	15	O
16	16	P
17	17	Q
18	18	R
19	19	S
20	20	T
21	21	U
22	22	V
23	23	W
24	24	X
25	25	Y
26	26	Z

[rizmomin]

Hi Kaper:

Thank you so much

Riz