Wauvel

Excel like a finance pro.

← The library

Text function

CHAR

Returns the character for a code number; CHAR(10) is a line break.

CommonDifficulty 1100 · ProficientUsage rank #131 of 520
Practice · 2 questions →

When to use it

The character for an ANSI code 1 to 255. Line breaks (10), quotes (34), and symbols.

The shape of it

Syntax
=CHAR(number)

Worked examples

  • A letter

    =CHAR(65) → A

    Code 65.

  • Line break

    ="Line1"&CHAR(10)&"Line2" → Line1 (break) Line2

    A line break inside a cell; turn on Wrap Text to see it.

  • Symbol

    =CHAR(169) → ©

    Copyright symbol.

Worth knowing

  • CHAR(34) puts a double quote inside a text formula.
  • UNICHAR for anything beyond 255, such as arrows and check marks.
  • Alphabet sequence: CHAR(SEQUENCE(26,1,65)).

Where it goes wrong

  • Codes above 255 return #VALUE!; use UNICHAR.
  • Characters 128 to 255 depend on the system code page.

Related

LEFTRIGHTLENTRIMUPPERLOWER

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.