Clean up text
Repeat text or make an in-cell bar
=REPT("*",A2)How it works in Excel
- "*" is the text to repeat.
- A2 is how many times.
- Use "|" to make a simple bar chart inside a cell.
The idea in general
It prints the same thing again and again.
What I assumed
- The number is in A2.
Check the result on your own data before relying on it.