REPT Function in Apple Numbers: Repeat Text for Labels, Symbols and Worksheets

REPT generates repeated text in one cell. This is useful for quick quality-control markers, visual inspection of small ratings, separators in an export, or building fixed-width labels. It returns text, even when its first argument is a number: Apple explicitly demonstrates repeating numeric 5 to produce "555". This makes the difference between =5*3, which is numeric fifteen, and =REPT(5,3), which is the text "555".

Text repetition is not the same as filling a range with values, copying a formula down, or creating a data-driven chart. A block of repeated glyphs can also be less accessible than displaying a numeric score beside the text. Use genuine chart/data-bar features when accurate quantitative comparisons matter.

=REPT(source-string, repeat-number)

Argument: source-string

Required?
Yes

Apple-documented type
Any value

Meaning
Text or other input to be represented in the repeated string.

Argument: repeat-number

Required?
Yes

Apple-documented type
Number value

Meaning
Number of repetitions; Apple explicitly requires a value greater than or equal to 0.

The order matters: the content first, the count second. The Apple help page does not give a third argument, a default count, a maximum output length, or documented fractional-count coercion. Accordingly, examples here use small, nonnegative whole-number counts. This article does not import Excel’s fractional-truncation or 32,767-character behaviour into Numbers. Apple’s support page is part of Formulas and Functions Help 15.4; it does not establish the first Numbers release that supported REPT or guarantee identical edge handling in every past macOS, iOS, iPadOS, and web edition. Function documentation; function conventions.

Locales and formula entry

The examples use English-function notation with a comma between the arguments: =REPT("+",4). Apple’s function overview says that if your decimal separator is a comma, type a semicolon between arguments instead: =REPT("+";4). The quoted text stays quoted and the repeat count stays numeric. Function names are case-insensitive when typed manually. A cell reference such as =REPT(A2,B2) is suitable for repeatable tests; see Apple’s cell-reference instructions.

For each row, enter the displayed formula in an otherwise empty text-result cell. Expected results are not observations from the Numbers application; their status is marked below.

The repeated segments touch end-to-end. If you need spaces, include them inside the source text ("- ") rather than assuming REPT inserts a separator. This distinction matters when the result is copied to another system.

Create a simple Numbers table with headings Label, Units, Marker, and Note in cells A1:D1. Enter this data:

Row: 2

A: Label
Boxes

B: Units
3

C: Marker formula
=REPT("■",B2)

D: expected text
■■■

Row: 3

A: Label
Bags

B: Units
1

C: Marker formula
=REPT("■",B3)

D: expected text
■

Row: 4

A: Label
Crates

B: Units
5

C: Marker formula
=REPT("■",B4)

D: expected text
■■■■■

Enter the formula in C2 and use Numbers’ copy/fill mechanism for the other rows, or type the row-specific formulas as shown. Change B2 from 3 to 4 and verify that the mathematical expectation for the marker becomes ■■■■. The input is small on purpose: repeating blocks thousands of times is an awkward way to build a dashboard.

How to verify in Numbers later: Use a fresh table rather than a screenshot. Confirm that C2 displays three blocks when B2 is 3, that B3 displays one block, and that the marker is stored as a text result. Record the exact app version, device, regional settings and actual observed results if native testing becomes available.

Simple fixed-width separators

=REPT("-",12) is expected to produce twelve hyphens (------------). This can help create a human-readable separator in a copied plain-text report. It is not a page border and does not adapt to column width or font choice. Use table-border formatting instead of text separators in a polished Numbers workbook.

Repeated status symbols

If a 1–5 integer rating appears in B2, =REPT("★",B2) is expected to return one star per rating point. Show the numeric score as well for readers who cannot distinguish symbols, and validate the input as an integer from 1 through 5. Do not use arbitrary decimals without deciding how they should be rounded—Apple’s REPT entry does not document fractional repetition.

Repeating a complete token

=REPT("CA-",3) is expected to return CA-CA-CA-. Every character in the original token is repeated, including the hyphen. If you need a delimiter only between tokens, do not assume REPT automatically trims the trailing hyphen; build that output deliberately and test the composition.

Generating small test identifiers

=REPT("0",4) has the expected textual output 0000. This is not a substitute for proper numeric formatting; it is a string of four zero characters. Leading zeroes are meaningful in postal codes or IDs, so avoid converting such outputs to numbers unless the zeros are truly insignificant.

Zero count: Apple’s documentation allows repeat-number = 0 by its nonnegative rule, but the example page does not show the resulting text. Empty text is the natural mathematical expectation; keep a native-zero test pending rather than presenting this as an observed Apple result. Large outputs, empty source strings, emoji grapheme handling and booleans also remain untested in the native application.

In all three, the simple whole-number examples above express the same intended text repetition. That shared concept is not evidence of matching hidden coercion rules, exact failures, or historical version coverage.

For editing existing substrings rather than generating repeated characters, see REPLACE and SUBSTITUTE in Apple’s function list. TEXTJOIN suits combining separate text values with a chosen delimiter; TRIM concerns unwanted spaces. Choose the operation that matches the desired text transformation.

Official sources consulted 2026-10-12: REPT, Apple Functions Help 15.4; Functions overview and regional syntax, Apple; Apple function catalogue; Microsoft Excel REPT; Google Sheets REPT.

• CHAR — continue with a related Apple Numbers calculation.
• CODE — continue with a related Apple Numbers calculation.
• CLEAN — continue with a related Apple Numbers calculation.
• T — continue with a related Apple Numbers calculation.
• FIXED — continue with a related Apple Numbers calculation.

For a software-specific comparison: Microsoft Excel REPT, Google Sheets REPT, LibreOffice Calc REPT. A shared name does not establish identical argument, error or version behaviour.

The linked official function documentation was reviewed on October 12, 2026. Apple’s Formulas and Functions Help 15.4 identifies the documentation edition, not a minimum Numbers release or a guarantee of historical platform parity. Selected worked examples were checked using independent mathematical or text-processing models; results are expected values, not observations from the spreadsheet application. Native Apple Numbers execution was not performed. Undocumented coercion, exact error messages and platform-specific behaviour remain unverified.

View reproducible example inputs and independent check results. This record is not a native spreadsheet test log.