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

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.


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. 

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.


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

<< Go Back to Excel CHAR Function | Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF