How to Convert Excel ASCII to Char (An Easy Way)

Get FREE Advanced Excel Exercises with Solutions!

American Standard Code for Information Interchange (ASCII) is a character encoding standard for electronic devices. In its 7-bit version, it supports characters denoted by numbers 1-127 in Excel. Users from time to time need to insert certain characters, thus requiring the Excel ASCII to char conversion.

Excel ASCII to Char-ASCII Table

In this article, we demonstrate the ASCII table, ASCII to character, and character to ASCII code (number) conversions.


ASCII Table

Users are familiar with the ASCII table that depicts the characters against ASCII codes. Users use those codes in various formulas to insert desired characters. The characters include digits 0-9, lowercase alphabets a-z, uppercase alphabets A-Z, and punctuation. These characters are divided into two sections; Non-printable Control Characters (first 31 characters) and Printable Characters.

Excel ASCII to Char-ASCII Table

Read More: Character Codes for CHAR Function in Excel


How to Convert Excel ASCII to Char: Use of CHAR Function

Excel offers the CHAR function to simply convert numbers (i.e., ASCII code) into characters. Also, to achieve the other way around, users can use the CODE function.

Go through the below section to learn more about Excel ASCII to character conversion and vice versa.

The CHAR function takes a number and returns a single character. For extended versions of ASCII or ANSI it supports 1-255 numbers. The syntax of the CHAR function is:

CHAR (number)

The number ranges from 1-255.

  • Use the below formula in the cells to convert ASCII to character. 
=CHAR(B4)

ASCII to Char

  • On the contrary, the CODE function converts the characters into ASCII codes or numbers.

The VBA Asc function does the same as the CODE function in Excel VBA.

⧭ Note: The modern Unicode system supports universal characters. Excel also has two other functions to deal with it: UNICHAR and UNICODE.

Read More: How to Use Code 9 with Excel CHAR Function


Things to Remember

  • Excel CHAR function results in an #VALUE error whenever:
    • Insert number out of the 1-255
    • Assign 0 to the argument.
  • The outcome of the function is String/Text.
  • The CODE function is the inverse of the CHAR function.
  • Excel VBA also supports the function.
  • Characters for numbers greater than 255, use the UNICHAR function.

Download Excel Workbook

Download the attached dataset to clarify the functions and their outcomes.


Conclusion

This article discusses the ASCII table and the conversion of Excel ASCII to Char or the opposite. I hope this article sheds enough light to give you a workable understanding of ASCII and its characters’ encoding. Comment if you have further inquiries or have anything to add.

Do check out our excellent website to find interesting articles on Excel.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Maruf Islam
Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo