Formualizer Docs
ReferenceFunctionsText Functions

RIGHT

Returns the rightmost characters from a text value.

Summary

Returns the rightmost 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 last three characters
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
ine
Default count is one
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
c

FAQ

If num_chars is larger than the text length, what is returned?

RIGHT returns the full text when the requested count exceeds available characters.

Runtime metadata

Category

Text

Signature

RIGHT(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

REPT

REPT: Repeats text a given number of times.

SEARCH

SEARCH: Returns the 1-based position of one text string inside another.

On this page

SummaryRemarksExamplesRelated functionsFAQIf num_chars is larger than the text length, what is returned?Runtime metadata