Skip to content
Google Sheets

CHAR function in Google Sheets

Convert a number into a character according to the current Unicode table.

=CHAR(table_number)

CHAR syntax and parameters

One argument, one required.

  • table_numbernumberRequired

    The number of the character to look up from the current Unicode table in decimal format. table_number must be a number in decimal format (base 10). Many tables provide Unicode values in hexadecimal format (base 16). In this case, use the HEX2DEC function to convert.

CHAR examples

Formulas you'll actually reuse.

  1. Two lines joined with a line break (turn on wrap text):

    =A2 & CHAR(10) & B2

  2. Cycle A, B, C… down a column starting at row 2:

    =CHAR(65 + MOD(ROW() - 2, 26))

    Result"A"

CHAR in Excel

Same name — your formula ports as-is.

Try CHAR in the playground

Edit the example — nothing to install.

Preloaded with the CHAR formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.