deepcalc
DocsCHAR

CHAR

View as markdown/docs/functions/char.md Ask Claude about this pageOpens Claude with this page's address

Returns the character for a character-set code.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Text

Examples

=CHAR(65)
Result A

Syntax

CHAR(number)
number
number required

Errors

#VALUE!
=CHAR(300)
ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one. CONCATENATEJoins several text strings into one.