Google Sheets Special Characters

Build a progress bar using block characters that fills based on the percentage in cell A1 out of 100

Create a 5-star rating display using filled and empty star characters with REPT

Make a traffic light using filled circle characters (●) colored red, yellow, or green based on status in column B

Build a progress track using block characters and an arrow that moves along it with REPT and CHAR

Show up arrow, down arrow, or flat arrow based on whether a number is positive, negative, or zero

Create a yes/no display with a checkmark character from CHAR and an X for no

Make a battery level indicator using block characters and show the percentage next to it

Build a heart health bar that shows filled and empty hearts based on a score from 1 to 5

Create a sound level meter using block characters that grows with the value in A1

Make animated loading dots that cycle using REPT and MOD with NOW

Show gold, silver, or bronze star characters for ranks 1, 2, 3 and the number for everything else

Display a dice face using dot characters and box drawing based on a number from 1 to 6 using CHOOSE

Pick a weather symbol based on temperature ranges: sun, cloud, rain, snow characters

Add a bullet point character from CHAR before text in column B

Turn a comma-separated list in one cell into bullet points on separate lines using REGEXREPLACE and CHAR

Convert a comma-separated list into numbered lines with TEXTJOIN and SEQUENCE

Turn a comma-separated list into a checklist with empty checkbox characters on each line

Split a pipe-separated list into multiple lines inside one cell using REGEXREPLACE

Center or right-align text inside a cell using REPT and LEN with space padding

Add an underline made of box-drawing dashes below text using REPT and CHAR(10)

Build a two-column ASCII table top or middle row with box-drawing characters

Wrap label text in square brackets or curly quotes using CHAR

Truncate long text with an ellipsis when it exceeds a max character count

Draw a simple ASCII box border around content using box-drawing characters and CHAR(10) for newlines

Build a sparkline-style bar chart in a single cell using REPT and block characters

Show a mood indicator from sad to happy face characters based on a score from 1 to 5

Create a password strength bar with blocks and a text label of Strong, OK, or Weak

Show tree growth stages using block and line characters based on a level number

Build a compass arrow that points in 8 directions based on a number from 1 to 8

Combine CHAR and REPT to make a custom checkbox that shows a checkmark when TRUE and empty when FALSE

Create a horizontal bar race chart in one cell where an arrow character moves along a track of dots