# REPT

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function repeats text a specified number of times.

## Syntax

REPT(*text*,*number*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *text* | Text you want to repeat |
| *number* | Number of times you want to repeat the text; if not an integer, the number is truncated; if zero (0), returns empty (" ") |

## Remarks

The result of this function must be less than or equal to 255 characters.

## Data Types

Accepts string data for the *text* argument and numeric data for the *number* argument. Returns string data.

## Examples

`REPT(D9, 2)`
`REPT(R9C4, 2)`
`REPT("*4", 3)` gives the result `*4*4*4`

## Version Available

This function is available in product version 1.0 or later.

## See Also

[CONCATENATE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionCONCATENATE) \| [Text Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functstext)