### CHAR(number)

Returns the character with the corresponding ANSI/ASCII number.

 number The number specifying which character you want between 1 and 255.

#### Remarks

 * This function is useful when you want to specify characters that are difficult or impossible to type directly.* The "number" argument can be with or without leading zeros.* The "number" can be a text string representation of a number.* If "number" < 1, then #VALUE! is returned.* If "number" > 255, then #VALUE! is returned.* If "number" is not numeric, then #VALUE! is returned.* If you are using Windows then the character set is ANSI (which is identical to ASCII).* If you are using Macintosh then the character set is different to Windows.* For a full list of all the ASCII String Codes, please refer to the ASCII String Table page.* You can return a line break by using CHAR(10).* You can use the CODE function to return the ANSI/ASCII number for the first character in a text string.* You can use the UNICHAR function to return the character with the corresponding UNICODE number.* You can use the UNICODE function to return the UNICODE number for the first character in a text string.* For more information about the different character sets refer to the Character Codes page.* For the Microsoft documentation refer to support.office.com

 A 1 =CHAR(65) = A 2 =CHAR(66) = B 3 =CHAR(67) = C 4 =CHAR(97) = a 5 =CHAR(98) = b 6 =CHAR(128) = € 7 =CHAR(130) = , 8 =CHAR("00065") = A 9 =CHAR(70) = F 10 =CHAR(65+26) = [ 11 =CHAR(CODE("A")) = A 12 =CHAR(CODE("A")+32) = a 13 =CHAR(256) = #VALUE! 14 =CHAR(-10) = #VALUE! 15 =CHAR(40000) = #VALUE! 16 =CHAR("some text") = #VALUE!

 1 - What is the character corresponding to the number 65.