The Excel CODE function returns a numeric code for a given character. For example, CODE("a") returns the code 97. The CODE function can be used to figure out numeric codes supplied to the CHAR function.
Get the code for a character
A numeric code representing a character.
text - The text for which you want a numeric code.
CODE returns a numeric code for the first character in a text string. The code is based on the character set used by your computer.
The SUBSTITUTE function can find and replace text in a cell, wherever it occurs.
In this case, we are using SUBSTITUTE to find a character with code number 202, and replace it with an empty string (""), which...
Working from the inside out, the MID function is used to cast the string into an array of individual letters:
In this part of the formula, MID, ROW, INDIRECT, and...
The Excel CHAR function returns a character when given a valid character code. CHAR can be used to specify characters that are hard to enter in a formula. For example, CHAR(10) returns a line break on Windows, and CHAR(13) returns a line break on...