Fabric Plan Community Logo
Sign in

REPT

The REPT function repeats a text string a specified number of times. This function is commonly used to generate repeated text patterns and formatted outputs.

Syntax

REPT(value, count)

Arguments

  • value: The text string to repeat.
  • count: The number of times to repeat the text string.

Return value

Returns a text string repeated the specified number of times.

Example

REPT("Qtr-", 3)

Returns Qtr-Qtr-Qtr-.

Excel equivalent

REPT

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.