Number to Text (Ascii / Ansi) in Excel

G

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
 
Last edited by a moderator:
G

Guest

VLOOKUP will look up text and CHAR function converts numbers to characters
(ANSII)
 
Last edited by a moderator:

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
Excel Convert word into numbers and back 4
Convert ASCII to Text 1
Transfer Text in ANSI to export to legacy system 0
Converting ASCII comma delimited 1
How can i convert an ASCII character to decimal/hex in Excel? 1
Text files in ascii format 4
How can I use the same random number twice in the same formula? 2

Top