How To Use CHAR Function | Microsoft Excel

The CHAR Function is a text function which is used to place a character from the ASCII character set.

CHAR Function is working on two types of operating system Macintosh and Windows
Macintosh has its own Macintosh character set and Windows has ASCII Character set.

Syntax of CHAR Function

=CHAR(number)

Arguments of CHAR Function

number: It is mandatory. From the ASCII set you can write any number from 0 to 255. Some numbers have not specified characters.

Behaviour of CHAR Function

You can see the ASCII codes for different numbers from Here
Here we have used some of the codes for examples

The 33  number is dedicated to an Exclamation mark(!) same as 
37 is Percentage(%)
65 is Upper Case latter A(A)
51 is numerical value 3(3)
64 is At(@)
70 is Upper Case Latter F(F)

and As so on...

IMPORTANT NOTES

• The limit of the CHAR Function is from 0 to 255
• Some of the characters are not visible because they are specified for languages(For Example 0 is specified as null means break of the line)

Use of the CHAR Function
you can use such symbols and characters that are not available on the keyboard

Returns of the CHAR Function

CHAR Function returns the character from the computes's character set as per given value