Skip to content
Excel

CHAR function in Excel

Returns the character specified by the code number

=CHAR(number)

CHAR syntax and parameters

One argument, one required.

  • numbernumberRequired

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 Google Sheets

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 Excel gets this done.