Number to Text (Ascii / Ansi) in Excel

[Guest]

1. I would like a TLookUp Function like VLookup which is for text.
2. I would like a =ASCII(number) / =ANSI (number) to convert numbers to a
letter / sign

The TEXT function which converts a single number to a letter is not good
enough.

Best wishes

 

[Toppers]

VLOOKUP will look up text and CHAR function converts numbers to characters
(ANSII)