Text FunctionsIntermediate

REPT Function

Repeat text a specified number of times.

Task:

Create a simple bar chart using text by repeating a character based on the value in column A. Display the result in column B.

Interactive Spreadsheet

Read about REPT

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of REPT

0/3

The same formula in the other shapes it takes at work.

  1. REPT Function

    Repeat text a specified number of times.

    CoreIntermediate
  2. REPT with a scaled bar

    Big numbers need dividing down before they become a bar.

    Intermediate
  3. REPT to pad a number with zeros

    Make every ID the same width: as many zeros as are missing, then the number.

    Advanced

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

5 rows × 2 columns4 cells you fill in
AB
1ValueBar
25
310
43
57

Functions used here

What this exercise teachesMay contain the answer

The REPT function repeats a text string a specified number of times. It's useful for creating text-based visualizations or padding.