Convert ASCII to Text

C

chabuhi

I found the worksheet function that will give me the ascii code for
letter, but I can't seem to reverse the process in any way to get th
letter from the ascii code.

In other words, I can use


Code
-------------------
=CODE(A1
-------------------


to get the ASCII value for the letter in cell A1 (providing there'
just one letter in that cell). I can then basically subtract 64 to giv
me the base numerical value (1-26) of that letter.

Is there a formula for doing the opposite? So if the cell value is 20
then add 64 and give me the letter equivalent of ASCII value 84?

Thanks for any help
 

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 Cell Value to ASCII 1
The Kth element in a text list 15
Scrabble Value calculation for Welsh words 0
Incorporating feature of second macro into first? 5
Char Unicode value and converting to byte 2
convert byte() in ASCII code to letters? 7
How can i convert an ASCII character to decimal/hex in Excel? 1
Adding a number to a letter of the alphabet to get a letter 5

Top