Formualizer Docs
ReferenceFunctionsText Functions

UNICHAR

UNICHAR: Returns the Unicode character for a given code point.

Summary

Returns the Unicode character for a given code point.

Remarks

  • Input is truncated to an integer code point.
  • Code point 0, surrogate range, and values above 0x10FFFF return #VALUE!.
  • Errors are propagated unchanged.
  • Non-numeric inputs are coerced with numeric coercion rules.

Examples

Basic Unicode code point
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
☃
Invalid code point
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#VALUE!

FAQ

Which code points are invalid?

0, surrogate values, and anything above 0x10FFFF return #VALUE!.

Runtime metadata

Category

Text

Signature

UNICHAR(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

TRIM

TRIM: Removes leading/trailing whitespace and collapses internal runs to single spaces.

UNICODE

Returns the Unicode code point of the first character in text.

On this page

SummaryRemarksExamplesRelated functionsFAQWhich code points are invalid?Runtime metadata