CHAR

The CHAR function in Google Sheets converts a number into a character according to the current Unicode table. It's a handy way to insert special characters, symbols, or control codes directly from a numeric code. Dive into our comprehensive guide to master its application.

Parameters

• table_number: The number representing a character according to the current Unicode table.

Step-by-Step Tutorial

1. Using CHAR with a basic code:

   • Example: =CHAR(65)
   • Result: A

2. Using CHAR to insert a symbol:

   • Example: =CHAR(9731)
   • Result: ☃

Use Cases and Scenarios

1. Encoding: Convert numeric codes into their corresponding characters when working with data exports or imports.
2. Text Manipulation: Insert special characters, such as line breaks or symbols, into formulas.
3. Custom Labels: Build dynamic labels or bullet points using special Unicode characters.

Related Functions

• CODE: Returns the numeric Unicode value of the first character in a string.
• UNICHAR: Returns the character associated with a Unicode number.
• UNICODE: Returns the Unicode number of the first character in a string.

Related Articles

No related articles available for the CHAR function.