Text Functions
Intermediate
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.
Learning Objectives:
- Learn REPT function
- Understand text repetition
- Practice simple text visualizations
Hints
Solve without hints for +5 XP
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.
| A | B | |
|---|---|---|
| 1 | Value | Bar |
| 2 | 5 | |
| 3 | 10 | |
| 4 | 3 | |
| 5 | 7 |
What this exercise teaches (contains the answer)
The REPT function repeats a text string a specified number of times. It's useful for creating text-based visualizations or padding.