Repeat a character N times — great for star ratings or in-cell bars.
Copy this formula
=REPT("★", A2)REPT(text, n) repeats the text n times. Use it for star ratings, simple bar charts inside cells, or padding. Combine two REPT calls for a filled/empty rating display.
=REPT("█", ROUND(A2/10, 0))→██████A bar scaled to the value.
Star rating
=REPT("★", A2)&REPT("☆", 5-A2)Shows filled and empty stars out of 5.
Scale the value to a max (e.g. 20) before REPT and use a monospace font for alignment.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.