The Google Sheets function CHAR allows users to convert numeric values into their respective characters according to the Unicode table. This function is particularly useful for generating special characters, symbols, or any non-alphanumeric characters that may not be easily accessible through a keyboard. Understanding how to implement this function can enhance data presentation and formatting in your spreadsheets.
Syntax
CHAR(number)
- number: A numeric value representing the desired Unicode character. Valid inputs range from 0 to 1114111.
Example #1
CHAR(65)
This function translates the number 65 into the character ‘A’. Result: A
Example #2
CHAR(35)
This function converts the number 35 into the ” character. Result:
Example #3
CHAR(9731)
This function returns a snowflake symbol corresponding to the number 9731. Result: ❄
Error handling
- VALUE!: This error occurs if the input number is outside the valid range (0-1114111).
- NUM!: This error is returned when the input is non-numeric or inappropriate for character conversion.