Formualizer Docs
ReferenceFunctionsText Functions

CHAR

Returns the character specified by a number Excel uses Windows-1252 encoding for codes 1-255.

Summary

Returns the character represented by a numeric code.

CHAR follows Excel-style Windows-1252 behavior for codes 1..255.

Remarks

  • Input is truncated to an integer code.
  • Valid code range is 1 through 255; outside this range returns #VALUE!.
  • Codes in the Windows-1252 extension range (128-159) are mapped to Unicode equivalents.
  • Errors are propagated unchanged.

Examples

ASCII character
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
A
Out-of-range code
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#VALUE!

FAQ

Which character set does CHAR use for codes 128-159?

It follows Excel-style Windows-1252 mappings, including extended symbols in that range.

Runtime metadata

Category

Text

Signature

CHAR(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/text/char_code_rept.rs

ARRAYTOTEXT

ARRAYTOTEXT: Converts an array or range into a text representation.

CLEAN

CLEAN: Removes non-printable ASCII control characters from text.

On this page

SummaryRemarksExamplesRelated functionsFAQWhich character set does CHAR use for codes 128-159?Runtime metadata