convert a number to letter

3Suk · Jan 30, 2015

dear all,
if i have a number "2" in cell A1, how can i convert it to a letter B using formula located in cell C1?

Thanks,
Patrick.

Claus Busch · Jan 30, 2015

Hi Patrick,

Am Thu, 29 Jan 2015 18:27:14 -0800 (PST) schrieb 3Suk:

if i have a number "2" in cell A1, how can i convert it to a letter B using formula located in cell C1?

try:
=CHAR(A1+64)

Regards
Claus B.

3Suk · Jan 30, 2015

Hi Patrick,

Am Thu, 29 Jan 2015 18:27:14 -0800 (PST) schrieb 3Suk:

try:
=CHAR(A1+64)

Regards
Claus B.

Claus,
thanks.
PL.