Using Code and Char Functions

The CHAR and CODE functions in Excel are useful for working with characters and their numeric codes. The CHAR function returns the character corresponding to a given numeric code, while the CODE function returns the numeric code of a given character.

CODE Function

All characters have a character code, and Excel will tell you what it is if you apply the CODE function to them. The CODE function returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.

You can use the CODE function in various ways depending on your specific needs. For example, the formula =CODE("H") returns 72, which is the numeric code of H:

  • =CODE("a") returns 97
  • =CODE("A") returns 65
  • =CODE(1) returns 49

CHAR Function

The CHAR function returns a character based on a numeric code. The numeric code can range from 1 to 255, and corresponds to the character set used by your computer. For example, CHAR(65) returns A, CHAR(97) returns a, and CHAR(169) returns ©.

You can use the CHAR function to insert special characters or symbols into your worksheets, such as bullets, or currency symbols.

  • =CHAR(165) returns ¥
  • =CHAR(163) returns £
  • =CHAR(162) returns ¢
  • =CHAR(128) returns

Formula and Functions

  1. Extract Number From Cells That Mix of Text and Numbers
  2. Convert Text to Numbers
  3. Using Code and Char Function
  4. Creating Dependent Combo Box Using Option Buttons
  5. Convert Formulas to Values