Formualizer Docs
ReferenceFunctionsText Functions

LEFT

Returns the leftmost characters from a text value.

Summary

Returns the leftmost characters from a text value.

Remarks

  • num_chars defaults to 1 when omitted.
  • Negative num_chars returns #VALUE!.
  • If num_chars exceeds length, the full text is returned.
  • Non-text values are coerced to text before slicing.

Examples

Take first two characters
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
Fo
Default count is one
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
D

FAQ

What if num_chars is negative?

LEFT returns #VALUE! when num_chars is below zero.

Runtime metadata

Category

Text

Signature

LEFT(arg1…: Any)

This function accepts a repeating argument pattern (min args: 1).

Arity

min 1, max variadic

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

FIXED

Formats a number as text with fixed decimal places.

LEN

LEN: Returns the number of characters in a text value.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat if num_chars is negative?Runtime metadata