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.
 
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?
Click to expand...

try:
=CHAR(A1+64)


Regards
Claus B.
 

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

Similar Threads

convert a number to month 6
How to replace text with numbers? (formula) 3
hlookup with the sheet name is a reference from another cell 2
Excel Convert word into numbers and back 4
automatic calculation 3
capturing a letter 7
Convert Column number to a letter? e.g. Column 203 = GU 11
Find largest value in column with 2 criteria 1

Top