CHAR Function in Google Sheets: Examples, Pitfalls & Compatibility

=CHAR(table_number)

table_number (required): A numeric character code. The accepted code system depends on the application; see the platform note below.

Examples use English function names, comma argument separators and decimal points. Adapt formula separators to your workbook settings, not punctuation inside quoted text.

Use CHAR to insert a known separator or control character into a formula. It is also useful when a character is awkward to type directly. Do not assume that every numerical code has the same meaning across platforms, operating systems and fonts.

Each example is independent. Where input cells are listed, enter those values first; otherwise the formula is self-contained. Expected outputs are independently checked calculations or documented error expectations, not captured results from Google Sheets.

Example 1: Insert a Unicode check mark

=CHAR(10003)

Expected result: "✓" (quoted here to make spaces and text boundaries visible).

The decimal Unicode code point 10003 identifies the check mark. Its glyph still depends on font support.

Example 2: Insert a Unicode star

=CHAR(9733)

Expected result: "★" (quoted here to make spaces and text boundaries visible).

This larger code point is valid for the Unicode-based Sheets function but lies outside Excel CHAR’s documented argument range.

Example 3: Build a two-line label

="Review"&CHAR(10)&"done"

Expected result: "Review\ndone" (the \n notation represents a line feed in the stored string).

A line feed separates the two fragments. The test checks the text content, not a specific visual row height or wrapping setting.

Document why a code is used instead of leaving an unexplained number inside a long formula. For a line feed, first build a short two-part label and confirm the string before formatting the final report. A valid character can still be displayed as a missing-glyph box when the chosen font lacks it. Keep a plain-text alternative for important status symbols.

A valid character is not visible. Some codes describe controls such as a line feed, not a printable glyph. Check the string length or use a known printable code as a diagnostic.

A symbol changes after moving the workbook. Check which character-code system the formula expects. Excel CHAR is not a general Unicode equivalent of Google Sheets CHAR.

A square box appears instead of a symbol. The display font or device may not provide the requested glyph. This alone does not prove that the formula produced a different code.

Google Sheets CHAR uses decimal Unicode code numbers. This permits the check mark and star examples below, whose codes are outside Excel CHAR’s documented 1–255 range. A code number does not guarantee that every font will draw the symbol. See the vendor reference for the current definition.

The portable part of these examples is the ASCII subset and the deliberately chosen line feed. A Sheets CHAR call with a larger Unicode code point cannot simply be copied into Excel CHAR and assumed equivalent.

Compare the CHAR guide for Microsoft Excel and its official documentation. Having a guide in both libraries establishes two documented references, not a certificate of identical behavior across releases, locales or file conversions.

CODE, CLEAN, TEXTJOIN, LEN · All Google Sheets functions.

Editorial verification: Official references retrieved on 2026-10-12. The three worked cases are included in this release’s reproducible Python checking suite. It checks the stated arithmetic, calendar or text model and the expected documented error classification; it is not the Google Sheets calculation engine. No native application run, UI screenshot, maximum-size benchmark or cross-version certification is claimed. Review the editorial testing standards before relying on a formula in a critical workbook.