Converting an ASCII number back into letters?

[Yasir]

Does Excel have any functions that can convert a the ASCII character back into a letter? For example 65 back to "A"? Any help appreciated.

Cheers,
Yasir

*Edited because I got it completely wrong*!
This message was edited by Yasir on 2002-12-09 11:27
This message was edited by Yasir on 2002-12-09 11:46

 

[mjbeam]

Check out the TEXT function

 

[Joe Was]

Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.

Operating environment Character set
Macintosh Macintosh character set
Windows ANSI

Syntax
CODE(text)

Text is the text for which you want the code of the first character.

Example

Formula Description (Result)
=CODE("A") Displays the numeric code for A (65)
=CODE("!") Displays the numeric code for ! (33)



_________________<INPUT type="JSW" value=" Excel On... Coder's!" ID=Text1><spanstyle='font-size:36.0pt;color:#FFCC00'>JSW<o></o></span>[/b]</p><spanstyle='font-size:36.0pt;color:#FFCC00'>Try and try again, " The way of the coder!"<o></o></span>[/b]
This message was edited by Joe Was on 2002-12-09 11:42

 

[Yasir]

On 2002-12-09 11:39, mjbeam wrote:
Check out the TEXT function

Thanks for your help chaps. But I've inadvertently misled you in my first question. What I meant was, how can I convert an ASCII code back into a letter?

 

[Joe Was]

Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.

Operating environment Character set
Macintosh Macintosh character set
Windows ANSI

Syntax
CHAR(number)

Number is a number between 1 and 255 specifying which character you want. The character is from the character set used by your computer.

Formula Description (Result)
=CHAR(65) Displays the 65 character in the set (A)
=CHAR(33) Displays the 33 character in the set (!)

 

[Joe Was]

Note: Each of my messages came directly from Excel Help, you should be able to do the same? JSW

 

[Yasir]

On 2002-12-09 11:55, Joe Was wrote:
Note: Each of my messages came directly from Excel Help, you should be able to do the same? JSW

Joe thanks for your help. I've just realised that I've come across CHAR and Chr (VBA) before...my brain is not in gear today! Apologies!