Formualizer Docs
ReferenceFunctionsText Functions

REPT

REPT: Repeats text a given number of times.

Summary

Repeats a text string a specified number of times.

Remarks

  • Repeat count is truncated to an integer.
  • Negative counts return #VALUE!.
  • Output longer than 32,767 characters returns #VALUE!.
  • Non-text first argument is coerced to text.

Examples

Repeat text three times
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
ababab
Negative count
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#VALUE!

FAQ

Can REPT return very long strings?

Only up to 32,767 characters; longer results return #VALUE! like Excel.

Runtime metadata

Category

Text

Signature

REPT(arg1: Any, arg2: Any)

Arity

min 2, max 2

Arguments

arg1

Any · Scalar

arg2

Any · Scalar

Caps

PURE

Source

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

REPLACE

Replaces part of a text string by position.

RIGHT

Returns the rightmost characters from a text value.

On this page

SummaryRemarksExamplesRelated functionsFAQCan REPT return very long strings?Runtime metadata