convert a number to letter


3

3Suk

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.
 
Ad

Advertisements

C

Claus Busch

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top