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

Build a live clock where arrow characters spin like hour and minute hands using CHOOSE, HOUR, and MINUTE 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