Blog
Practical guides on repeating text: how the spreadsheet functions behave and where they stop, how to generate exact-length strings for testing, and what a text repeater is actually for.
-
How to Repeat Text in Excel and Google Sheets (REPT Function)
REPT is the built-in way to repeat text in a spreadsheet. It is also capped at roughly 32,000 characters and inserts no separator at all — here is exactly how it behaves in each app.
-
What Is a Text Repeater? Uses, Limits and How It Works
A short, factual explanation of what a text repeater does, who actually uses one, and how browser-based repeaters differ from spreadsheet formulas and scripts.
-
How to Test Character Limits With Repeated Text
Repeated text is the fastest way to find out whether a form actually enforces its maximum length. Here are the boundary values worth testing and the bugs each one exposes.