John Schnobrich \ Unsplash
Problems can arise when converting the character codes from one system to another system.
These problems result in garbled data.
Excel CHAR and CODE Functions
Excel has a number of functions that work with these numbers.
John Schnobrich \ Unsplash
CHAR and CODE work in all versions of Excel.
UNICHAR and UNICODE were introduced in Excel 2013.
The CHAR and UNICHAR functions return the character for a given code.
The CODE and UNICODE functions do the opposite and provide the code for a given character.
In Excel Online, you’ll manually enter the function.
In desktop versions of Excel, use the dialog box.
The exclamation mark character appears in cell B3 because its ANSI character code is 33.
When you select cell E2, the complete function=CHAR(A3)appears in theformula barabove the worksheet.
For example, the CHAR function can remove unwanted characters that appear with imported data.
If the text argument is left empty, the CODE function returns the #VALUE!
error value, as shown in row 2 in the image above.
The CODE function only displays the character code for a single character.
In this case, it is the number69which is the character code for the uppercase letterE.
The number64appears in cell B3.
This is the character code for the ampersand (&) character.
