In one of our previous blogs, we learned how to insert symbols and special characters in excel using an inbuilt ‘Insert’ ribbon tab > ‘Symbols’ function. Surprisingly, excel has also come up with a formula to characters in excel using character code. The function name is the CHAR formula in excel.
Using the Excel CHAR function, you can use the character number to insert a symbol in excel.
- When To Use CHAR Function in Excel
- Syntax and Argument
- CHAR Function – Examples in Excel
- List of All ANSI Character Codes for CHAR Excel Function
- Do Not Miss These Points
Let us begin now 😎
When To Use CHAR Function in Excel
CHAR formula is used to insert a particular character using the character code as an input argument. This function belongs to the Text function group, therefore the result of this function is a text formatted value.
The function returns the character based on the code number from the character set of your computer. Different operating systems work differently in this regard.
- Windows OS uses the ANSI character set
- Macintosh OS uses Macintosh character set
In this tutorial, we would cover the Windows OS ANSI character set for understanding.
Syntax and Argument
The argument of the CHAR function is explained as below:
- number – In this argument, specify the number (ranging between 1 to 255) of which you want to return the character.
As mentioned in the above section, this function will return a different result in different operating systems.
CHAR Function – Examples in Excel
Finally, let us now learn how to use the CHAR function in excel with the help of examples.
Ex. 1 – Insert Alphabet in Excel Cell Using ANSI Character Number
You can use the character number code and insert letters in the excel cell (both capital letters and small).
- For capital letters (A to Z), use the ANSI code numbers from 65 to 90.
- For small letters (a to z), use the ANSI code numbers from 97 to 122.
To insert the capital ‘M’ letter in a cell using the ANSI Code, simply use the following formula.
Similarly, to enter a non-capital ‘m’ letter in excel cell, use this formula:
Ex. 2 – Insert Numbers in Excel Cell Using ANSI Code
Similarly, use the ANSI code values from 48 to 57 (in sequence) to insert numbers between 0 and 9 in an excel cell using the CHAR formula.
Therefore, to return the number 5 using ANSI code, use the following formula:
Ex. 3 – Insert Copyright, Trade Mark (TM), Registered symbol in Excel Cell
In addition to the alphabets and numbers, the CHAR symbol is useful to insert copyright (inside a circle), trademark, and registered (inside a circle) sign in Excel cell.
The following image shows the CHAR codes for the ©, ®, and ™ symbols in excel.
See the below example formula:
As a result, excel returns the three symbols as shown in the image below:
Use CONCATENATE, CONCAT, TEXTJOIN, or the ampersand (&) symbol to combine a text and above symbols, like this:
As a result, excel would return the output as – ExcelUnlocked® in a cell.
The highly used practical application of the CHAR function is for inserting line breaks in a cell. I have already explained how to insert line breaks in an excel cell in a separate tutorial here.
Also, check this link to learn about how to insert degree symbol in excel using different methods (including CHAR formula code).
List of All ANSI Character Codes for CHAR Excel Function
Alanwood has provided an entire list of 255 ANSI characters on his website.
Do Not Miss These Points
- The CHAR function returns #VALUE! error code if you specify the number argument other than 1 to 255.
- The CHAR function is available since Excel 2000 version.
This brings us to the end of the tutorial on CHAR excel formula.
Thank You 🙂