Google Sheets Character Playground

Progress bars, star ratings, emoji scenes, and more. Copy a formula and paste it into any cell.

Block progress bar

REPT

Put a score 0-10 in A1. Filled blocks show progress.

=REPT("โ–ˆ",A1)&REPT("โ–‘",10-A1)

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–‘โ–‘

Star rating (5 stars)

REPT

Put rating 0-5 in A1.

=REPT("โ˜…",A1)&REPT("โ˜†",5-A1)

โ˜…โ˜…โ˜…โ˜†โ˜†

3 of 5 with White Star

REPT CHAR

Put rating 0-5 in A1. Filled stars use CHAR(9734).

=REPT(CHAR(9734),A1)&REPT(CHAR(9885),5-A1)

โ˜†โ˜†โ˜†โšโš

Star rating with Outlined White Star

REPT CHAR

Put rating 0-5 in A1. Uses outlined white star glyphs.

=REPT(CHAR(9885),A1)&REPT(CHAR(9734),5-A1)

โšโšโšโ˜†โ˜†

3 of 5 with Black Four Pointed Star

REPT CHAR

Put rating 0-5 in A1. Uses four-pointed star glyphs.

=REPT(CHAR(10022),A1)&REPT(CHAR(10023),5-A1)

โœฆโœฆโœฆโœงโœง

Star rating with White Four Pointed Star

REPT CHAR

Put rating 0-5 in A1. Uses white four-pointed stars.

=REPT(CHAR(10023),A1)&REPT(CHAR(10022),5-A1)

โœงโœงโœงโœฆโœฆ

Star rating with Stress Outlined White Star

REPT CHAR

Put rating 0-5 in A1. Uses stress-outlined star glyphs.

=REPT(CHAR(10025),A1)&REPT(CHAR(9885),5-A1)

โœฉโœฉโœฉโšโš

3 of 5 with Circled White Star

REPT CHAR

Put rating 0-5 in A1. Uses circled white star glyphs.

=REPT(CHAR(10026),A1)&REPT(CHAR(10023),5-A1)

โœชโœชโœชโœงโœง

Star rating with Open Centre Black Star

REPT CHAR

Put rating 0-5 in A1. Uses open-centre black stars.

=REPT(CHAR(10027),A1)&REPT(CHAR(10028),5-A1)

โœซโœซโœซโœฌโœฌ

3 of 5 with Black Centre White Star

REPT CHAR

Put rating 0-5 in A1. Uses black-centre white stars.

=REPT(CHAR(10028),A1)&REPT(CHAR(10027),5-A1)

โœฌโœฌโœฌโœซโœซ

Star rating with Outlined Black Star

REPT CHAR

Put rating 0-5 in A1. Uses outlined black star glyphs.

=REPT(CHAR(10029),A1)&REPT(CHAR(9885),5-A1)

โœญโœญโœญโšโš

3 of 5 with Heavy Outlined Black Star

REPT CHAR

Put rating 0-5 in A1. Uses heavy outlined black stars.

=REPT(CHAR(10030),A1)&REPT(CHAR(10025),5-A1)

โœฎโœฎโœฎโœฉโœฉ

Star rating with Pinwheel Star

REPT CHAR

Put rating 0-5 in A1. Uses pinwheel star glyphs.

=REPT(CHAR(10031),A1)&REPT(CHAR(10037),5-A1)

โœฏโœฏโœฏโœตโœต

3 of 5 with Shadowed White Star

REPT CHAR

Put rating 0-5 in A1. Uses shadowed white star glyphs.

=REPT(CHAR(10032),A1)&REPT(CHAR(9734),5-A1)

โœฐโœฐโœฐโ˜†โ˜†

Star rating with Eight Pointed Black Star

REPT CHAR

Put rating 0-5 in A1. Uses eight-pointed black stars.

=REPT(CHAR(10036),A1)&REPT(CHAR(10037),5-A1)

โœดโœดโœดโœตโœต

3 of 5 with Eight Pointed Pinwheel Star

REPT CHAR

Put rating 0-5 in A1. Uses eight-pointed pinwheel stars.

=REPT(CHAR(10037),A1)&REPT(CHAR(10036),5-A1)

โœตโœตโœตโœดโœด

Star rating with Six Pointed Black Star

REPT CHAR

Put rating 0-5 in A1. Uses six-pointed black stars.

=REPT(CHAR(10038),A1)&REPT(CHAR(10039),5-A1)

โœถโœถโœถโœทโœท

3 of 5 with Eight Pointed Rectilinear Black Star

REPT CHAR

Put rating 0-5 in A1. Uses rectilinear eight-pointed stars.

=REPT(CHAR(10039),A1)&REPT(CHAR(10040),5-A1)

โœทโœทโœทโœธโœธ

Star rating with Heavy Eight Pointed Rectilinear Black Star

REPT CHAR

Put rating 0-5 in A1. Uses heavy rectilinear stars.

=REPT(CHAR(10040),A1)&REPT(CHAR(10039),5-A1)

โœธโœธโœธโœทโœท

3 of 5 with Twelve Pointed Black Star

REPT CHAR

Put rating 0-5 in A1. Uses twelve-pointed black stars.

=REPT(CHAR(10041),A1)&REPT(CHAR(9734),5-A1)

โœนโœนโœนโ˜†โ˜†

Star rating with Circled Open Centre Eight Pointed Star

REPT CHAR

Put rating 0-5 in A1. Uses circled open-centre stars.

=REPT(CHAR(10050),A1)&REPT(CHAR(10036),5-A1)

โ‚โ‚โ‚โœดโœด

3 of 5 with White Medium Star

REPT CHAR

Put rating 0-5 in A1. Uses the medium white star emoji.

=REPT(CHAR(11088),A1)&REPT(CHAR(9734),5-A1)

โญโญโญโ˜†โ˜†

Star rating with Glowing Star

REPT CHAR UNICHAR

Put rating 0-5 in A1. Filled stars use UNICHAR(127775).

=REPT(UNICHAR(127775),A1)&REPT(CHAR(11088),5-A1)

๐ŸŒŸ๐ŸŒŸ๐ŸŒŸโญโญ

Light block progress

REPT

Put a score 0-10 in A1. Lighter shade blocks.

=REPT("โ–“",A1)&REPT("โ–‘",10-A1)

โ–“โ–“โ–“โ–“โ–“โ–“โ–“โ–“โ–‘โ–‘

Car trip to mountain

REPT MAX

Put trip progress 0-10 in A1. Car moves toward the mountain.

="๐Ÿ”๏ธ"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿ”๏ธใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿš—ใƒปใƒป

Take Ring to Mordor

REPT MAX

Put journey progress 0-10 in A1. Ring travels from mountain to home.

=๐Ÿ”๏ธ&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’"&REPT("ใƒป",MAX(0,A1-2))&"๐Ÿ "

๐Ÿ”๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿ’ใƒปใƒปใƒป๐Ÿ 

Car trip to McDonald's

REPT MAX

Put trip progress 0-10 in A1. Car drives toward the fries.

="๐ŸŸ"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐ŸŸใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿš—ใƒปใƒป

Burger run by car

REPT MAX

Put trip progress 0-10 in A1. Car drives toward a hamburger.

="๐Ÿ”"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿ”ใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿš—ใƒปใƒป

Soda run to drink break

REPT MAX

Put break progress 0-10 in A1. Soda moves toward a drink break.

="โ˜•"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿฅค"&REPT("ใƒป",MAX(0,A1-2))

โ˜•ใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿฅคใƒปใƒป

Snack run to snack break

REPT MAX

Put break progress 0-10 in A1. Snack moves toward popcorn.

="๐Ÿฟ"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿช"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿฟใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿชใƒปใƒป

Traffic light status

IF

Put red, yellow, or green in A1.

=IF(A1="red","๐Ÿ”ด",IF(A1="yellow","๐ŸŸก","๐ŸŸข"))

๐ŸŸข

Yes / No status lights

IF LOWER

Put yes or no in A1. Anything else shows yellow.

=IF(LOWER(A1)="yes","๐ŸŸข",IF(LOWER(A1)="no","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

Approved / Not Approved thumbs

IF LOWER

Put approved or not approved in A1. Anything else shows shrug.

=IF(LOWER(A1)="approved","๐Ÿ‘",IF(LOWER(A1)="not approved","๐Ÿ‘Ž","๐Ÿคท"))

๐Ÿ‘

Pass / Fail status lights

IF LOWER

Put pass or fail in A1.

=IF(LOWER(A1)="pass","๐ŸŸข",IF(LOWER(A1)="fail","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

True / False status lights

IF LOWER

Put true or false in A1.

=IF(LOWER(A1)="true","๐ŸŸข",IF(LOWER(A1)="false","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

On / Off status lights

IF LOWER

Put on or off in A1.

=IF(LOWER(A1)="on","๐ŸŸข",IF(LOWER(A1)="off","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

Go / Stop status lights

IF LOWER

Put go or stop in A1.

=IF(LOWER(A1)="go","๐ŸŸข",IF(LOWER(A1)="stop","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

Active / Inactive status lights

IF LOWER

Put active or inactive in A1.

=IF(LOWER(A1)="active","๐ŸŸข",IF(LOWER(A1)="inactive","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

Done / Pending status lights

IF LOWER

Put done or pending in A1. Other values show red.

=IF(LOWER(A1)="done","๐ŸŸข",IF(LOWER(A1)="pending","๐ŸŸก","๐Ÿ”ด"))

๐ŸŸข

Paid / Unpaid status lights

IF LOWER

Put paid or unpaid in A1.

=IF(LOWER(A1)="paid","๐ŸŸข",IF(LOWER(A1)="unpaid","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

In stock / Out of stock lights

IF LOWER

Put in stock or out of stock in A1.

=IF(LOWER(A1)="in stock","๐ŸŸข",IF(LOWER(A1)="out of stock","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

Complete / Incomplete status lights

IF LOWER

Put complete or incomplete in A1.

=IF(LOWER(A1)="complete","๐ŸŸข",IF(LOWER(A1)="incomplete","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

Open / Closed status lights

IF LOWER

Put open or closed in A1.

=IF(LOWER(A1)="open","๐ŸŸข",IF(LOWER(A1)="closed","๐Ÿ”ด","๐ŸŸก"))

๐ŸŸข

Yes / No thumbs

IF LOWER

Put yes or no in A1. Anything else shows shrug.

=IF(LOWER(A1)="yes","๐Ÿ‘",IF(LOWER(A1)="no","๐Ÿ‘Ž","๐Ÿคท"))

๐Ÿ‘

Pass / Fail celebration

IF LOWER

Put pass or fail in A1. Anything else shows thinking face.

=IF(LOWER(A1)="pass","๐ŸŽ‰",IF(LOWER(A1)="fail","๐Ÿ˜ฌ","๐Ÿค”"))

๐ŸŽ‰

Go / Stop road signs

IF LOWER

Put go or stop in A1. Anything else shows pause.

=IF(LOWER(A1)="go","๐Ÿ",IF(LOWER(A1)="stop","๐Ÿ›‘","โธ๏ธ"))

๐Ÿ

Active / Inactive energy

IF LOWER

Put active or inactive in A1. Anything else shows sleeping.

=IF(LOWER(A1)="active","โšก",IF(LOWER(A1)="inactive","๐Ÿ’ค","๐Ÿ˜ด"))

โšก

Done / Pending clocks

IF LOWER

Put done or pending in A1. Anything else shows hourglass.

=IF(LOWER(A1)="done","โœ…",IF(LOWER(A1)="pending","โณ","โŒ›"))

โœ…

Paid / Unpaid money

IF LOWER

Put paid or unpaid in A1. Anything else shows question.

=IF(LOWER(A1)="paid","๐Ÿ’ฐ",IF(LOWER(A1)="unpaid","๐Ÿ’ธ","โ“"))

๐Ÿ’ฐ

In stock / Out of stock boxes

IF LOWER

Put in stock or out of stock in A1. Anything else shows shrug.

=IF(LOWER(A1)="in stock","๐Ÿ“ฆ",IF(LOWER(A1)="out of stock","๐Ÿ“ญ","๐Ÿคท"))

๐Ÿ“ฆ

Complete / Incomplete puzzle

IF LOWER

Put complete or incomplete in A1. Anything else shows magnifier.

=IF(LOWER(A1)="complete","๐Ÿงฉ",IF(LOWER(A1)="incomplete","๐Ÿšง","๐Ÿ”"))

๐Ÿงฉ

Open / Closed locks

IF LOWER

Put open or closed in A1. Anything else shows key.

=IF(LOWER(A1)="open","๐Ÿ”“",IF(LOWER(A1)="closed","๐Ÿ”’","๐Ÿ”‘"))

๐Ÿ”“

True / False marks

IF LOWER

Put true or false in A1. Anything else shows question mark.

=IF(LOWER(A1)="true","โœ…",IF(LOWER(A1)="false","โŒ","โ”"))

โœ…

On / Off power

IF LOWER

Put on or off in A1. Anything else shows unplugged.

=IF(LOWER(A1)="on","๐Ÿ’ก",IF(LOWER(A1)="off","๐ŸŒ™","๐Ÿ”Œ"))

๐Ÿ’ก

Win / Lose trophies

IF LOWER

Put win or lose in A1. Anything else shows handshake.

=IF(LOWER(A1)="win","๐Ÿ†",IF(LOWER(A1)="lose","๐Ÿ˜ข","๐Ÿค"))

๐Ÿ†

Accept / Decline hands

IF LOWER

Put accept or decline in A1. Anything else shows shrug.

=IF(LOWER(A1)="accept","๐Ÿ™Œ",IF(LOWER(A1)="decline","๐Ÿ™…","๐Ÿคท"))

๐Ÿ™Œ

Safe / Danger shields

IF LOWER

Put safe or danger in A1. Anything else shows skull.

=IF(LOWER(A1)="safe","๐Ÿ›ก๏ธ",IF(LOWER(A1)="danger","โš ๏ธ","โ˜ ๏ธ"))

๐Ÿ›ก๏ธ

Online / Offline signal

IF LOWER

Put online or offline in A1. Anything else shows sync.

=IF(LOWER(A1)="online","๐Ÿ“ถ",IF(LOWER(A1)="offline","๐Ÿ“ต","๐Ÿ”„"))

๐Ÿ“ถ

Like / Dislike hearts

IF LOWER

Put like or dislike in A1. Anything else shows neutral face.

=IF(LOWER(A1)="like","โค๏ธ",IF(LOWER(A1)="dislike","๐Ÿ’”","๐Ÿ˜"))

โค๏ธ

Ship / Hold delivery

IF LOWER

Put ship or hold in A1. Anything else shows magnifier.

=IF(LOWER(A1)="ship","๐Ÿš€",IF(LOWER(A1)="hold","โธ๏ธ","๐Ÿ”"))

๐Ÿš€

Success / Error bursts

IF LOWER

Put success or error in A1. Anything else shows warning.

=IF(LOWER(A1)="success","๐ŸŽŠ",IF(LOWER(A1)="error","๐Ÿ’ฅ","โš ๏ธ"))

๐ŸŽŠ

Healthy / Sick wellness

IF LOWER

Put healthy or sick in A1. Anything else shows sneeze.

=IF(LOWER(A1)="healthy","๐Ÿ’ช",IF(LOWER(A1)="sick","๐Ÿค’","๐Ÿคง"))

๐Ÿ’ช

Up / Down votes

IF LOWER

Put up or down in A1. Anything else shows sideways arrow.

=IF(LOWER(A1)="up","โฌ†๏ธ",IF(LOWER(A1)="down","โฌ‡๏ธ","โžก๏ธ"))

โฌ†๏ธ

Ready / Not ready checklist

IF LOWER

Put ready or not ready in A1. Anything else shows clipboard.

=IF(LOWER(A1)="ready","โœ…",IF(LOWER(A1)="not ready","๐Ÿ“‹","๐Ÿ“"))

โœ…

Available / Busy calendar

IF LOWER

Put available or busy in A1. Anything else shows calendar.

=IF(LOWER(A1)="available","โœจ",IF(LOWER(A1)="busy","๐Ÿ”ฅ","๐Ÿ“…"))

โœจ

Yes / No checkmarks

IF CHAR

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10004)&" Yes","โœ— No")

โœ” Yes

Yes / No with light check mark

IF CHAR

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10003)&" Yes",CHAR(10007)&" No")

โœ“ Yes

Yes / No with heavy ballot X

IF CHAR

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10004)&" Yes",CHAR(10008)&" No")

โœ” Yes

Yes / No with multiplication X

IF CHAR

Put Yes or No in A1. No uses a multiplication X.

=IF(A1="Yes",CHAR(10003)&" Yes",CHAR(10006)&" No")

โœ“ Yes

Yes / No ballot boxes

IF CHAR

Checked box for Yes, empty box for No.

=IF(A1="Yes",CHAR(9745)&" Yes",CHAR(9744)&" No")

โ˜‘ Yes

Yes / No ballot box and X box

IF CHAR

Checked box for Yes, X box for No.

=IF(A1="Yes",CHAR(9745)&" Yes",CHAR(9746)&" No")

โ˜‘ Yes

Yes / No checkbox only

IF CHAR

Put Yes or No in A1. Shows only the box glyph.

=IF(A1="Yes",CHAR(9745),CHAR(9744))

โ˜‘

TRUE / FALSE checkbox

IF CHAR

Put TRUE or FALSE in A1.

=IF(A1=TRUE,CHAR(9745),CHAR(9744))

โ˜‘

Yes / No emoji checks

IF

Put Yes or No in A1. Uses emoji check and X.

=IF(A1="Yes","โœ… Yes","โŒ No")

โœ… Yes

Yes / No check glyphs only

IF CHAR

Put Yes or No in A1. No text label.

=IF(A1="Yes",CHAR(10004),CHAR(10007))

โœ”

Yes / No case-insensitive checks

IF LOWER CHAR

Put yes or no in A1. Any casing works.

=IF(LOWER(A1)="yes",CHAR(10004)&" Yes",CHAR(10007)&" No")

โœ” Yes

Done / Todo checkmarks

IF LOWER CHAR

Put Done or Todo in A1.

=IF(LOWER(A1)="done",CHAR(10004)&" Done",CHAR(10007)&" Todo")

โœ” Done

Approved / Rejected checkmarks

IF LOWER CHAR

Put Approved or Rejected in A1.

=IF(LOWER(A1)="approved",CHAR(10004)&" Approved",CHAR(10008)&" Rejected")

โœ” Approved

Pass / Fail checkmarks

IF LOWER CHAR

Put Pass or Fail in A1.

=IF(LOWER(A1)="pass",CHAR(10003)&" Pass",CHAR(10007)&" Fail")

โœ“ Pass

Complete / Incomplete checkmarks

IF LOWER CHAR

Put Complete or Incomplete in A1.

=IF(LOWER(A1)="complete",CHAR(10004)&" Complete",CHAR(9744)&" Incomplete")

โœ” Complete

Checked / Unchecked with labels

IF LOWER CHAR

Put Checked or Unchecked in A1.

=IF(LOWER(A1)="checked",CHAR(9745)&" Checked",CHAR(9744)&" Unchecked")

โ˜‘ Checked

Heavy check or empty for Yes

IF CHAR

Put Yes in A1 for a checkmark. Anything else stays blank.

=IF(A1="Yes",CHAR(10004),"")

โœ”

Trend arrows

IF

Put a number in A1. Positive shows up, negative down, zero flat.

=IF(A1>0,"โ–ฒ "&A1,IF(A1<0,"โ–ผ "&A1,"โ†’ 0"))

โ–ฒ 12

Braille micro-bar

REPT

Put a score 0-5 in A1. Tiny braille progress bar.

=REPT("โ ฟ",A1)&REPT("โ €",5-A1)

โ ฟโ ฟโ ฟโ €โ €

Battery level

REPT ROUND MIN MAX

Put a percentage 0-100 in A1. Five blocks = 100%.

=REPT("โ–ˆ",MIN(5,MAX(0,ROUND(A1*5/100,0))))&REPT("โ–‘",5-MIN(5,MAX(0,ROUND(A1*5/100,0))))&" "&A1&"%"

โ–ˆโ–ˆโ–ˆโ–‘โ–‘ 60%

Heart health bar

REPT

Put HP 0-5 in A1. Filled hearts show remaining health.

=REPT("โ™ฅ",A1)&REPT("โ™ก",5-A1)

โ™ฅโ™ฅโ™ฅโ™กโ™ก

Sound level meter

LEFT MIN

Put volume level 0-8 in A1.

=LEFT("โ–โ–‚โ–ƒโ–„โ–…โ–†โ–‡โ–ˆ",MIN(A1,8))

โ–โ–‚โ–ƒโ–„โ–…

Loading dots

REPT MOD NOW

Animates with NOW(). No input needed; recalculates on refresh.

=REPT("โ—",MOD(NOW()*86400,4))&REPT("โ—‹",4-MOD(NOW()*86400,4))

โ—โ—โ—‹โ—‹

12-hour clock dots

REPT NOW HOUR

Filled dots show the current hour on a 12-hour clock. Empty dots fill the rest. Updates whenever NOW() changes.

=REPT("โ—",HOUR(NOW()))&REPT("โ—‹",12-HOUR(NOW()))

โ—โ—โ—โ—โ—โ—โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹

24-hour clock dots

REPT NOW HOUR

Filled dots show the current hour on a 24-hour clock. Empty dots fill the rest. Updates whenever NOW() changes.

=REPT("โ—",HOUR(NOW()))&REPT("โ—‹",24-HOUR(NOW()))

โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹

Medal podium

IF

Put rank 1, 2, or 3 in A1 for a medal. Other ranks show the number.

=IF(A1=1,"๐Ÿฅ‡",IF(A1=2,"๐Ÿฅˆ",IF(A1=3,"๐Ÿฅ‰"," "&A1)))

๐Ÿฅ‡

Dice face

CHOOSE

Put 1-6 in A1 for a dice face.

=CHOOSE(A1,"โš€","โš","โš‚","โšƒ","โš„","โš…")

โš‚

Dice face by name

SWITCH LOWER

Put one, two, three, four, five, or six in A1 for a dice face.

=SWITCH(LOWER(A1),"one","โš€","two","โš","three","โš‚","four","โšƒ","five","โš„","six","โš…")

โš‚

Weather row

IF

Put temperature in A1. Hot is sunny, cold is snowy.

=IF(A1>80,"โ˜€๏ธ",IF(A1>50,"โ›…",IF(A1>20,"๐ŸŒง๏ธ","โ„๏ธ")))

โ›…

Bullet list char

CHAR

Put list text in B1. Adds a bullet prefix.

=CHAR(8226)&" "&B1

โ€ข Item

Comma list to bullet points

CHAR REGEXREPLACE

Put a comma-separated list in B1. Each item gets its own bullet. Turn on Wrap text.

=CHAR(8226)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(8226)&" ")

โ€ข Apple โ€ข Banana โ€ข Orange

Comma list to line breaks

REGEXREPLACE CHAR

Put a comma-separated list in B1. Each item on its own line. Turn on Wrap text.

=REGEXREPLACE(B1, ",\s*", CHAR(10))

Apple Banana Orange

Comma list to numbered lines

TEXTJOIN SEQUENCE SPLIT CHAR

Put a comma-separated list in B1. Each item gets a number. Turn on Wrap text.

=TEXTJOIN(CHAR(10),TRUE,SEQUENCE(COUNTA(SPLIT(B1,",")))&". "&TRIM(SPLIT(B1,",")))

1. Apple 2. Banana 3. Orange

Comma list to dash lines

REGEXREPLACE CHAR

Put a comma-separated list in B1. Each item starts with a dash. Turn on Wrap text.

="- "&REGEXREPLACE(B1, ",\s*", CHAR(10)&"- ")

- Apple - Banana - Orange

Comma list to checklist

CHAR REGEXREPLACE

Put a comma-separated list in B1. Empty checkbox before each item. Turn on Wrap text.

=CHAR(9744)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(9744)&" ")

โ˜ Apple โ˜ Banana โ˜ Orange

Comma list to arrow lines

CHAR REGEXREPLACE

Put a comma-separated list in B1. Arrow before each item. Turn on Wrap text.

=CHAR(8594)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(8594)&" ")

โ†’ Apple โ†’ Banana โ†’ Orange

Comma list to star bullets

CHAR REGEXREPLACE

Put a comma-separated list in B1. Star before each item. Turn on Wrap text.

=CHAR(9733)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(9733)&" ")

โ˜… Apple โ˜… Banana โ˜… Orange

Comma list to indented bullets

CHAR REGEXREPLACE

Put a comma-separated list in B1. Indented bullets on each line. Turn on Wrap text.

=" "&CHAR(8226)&" "&REGEXREPLACE(B1, ",\s*", CHAR(10)&" "&CHAR(8226)&" ")

โ€ข Apple โ€ข Banana โ€ข Orange

Comma list to double-spaced lines

REGEXREPLACE CHAR

Put a comma-separated list in B1. Blank line between each item. Turn on Wrap text.

=REGEXREPLACE(B1, ",\s*", CHAR(10)&CHAR(10))

Apple Banana Orange

Pipe list to line breaks

REGEXREPLACE CHAR

Put a pipe-separated list in B1. Each segment on its own line. Turn on Wrap text.

=REGEXREPLACE(B1, "\|\s*", CHAR(10))

Apple Banana Orange

Semicolon list to bullet points

CHAR REGEXREPLACE

Put a semicolon-separated list in B1. Bullet on each line. Turn on Wrap text.

=CHAR(8226)&" "&REGEXREPLACE(B1, ";\s*", CHAR(10)&CHAR(8226)&" ")

โ€ข Apple โ€ข Banana โ€ข Orange

Text with underline

LEN REPT CHAR

Put text in A1. Line of dashes below the text. Turn on Wrap text.

=A1&CHAR(10)&REPT("โ”€",LEN(A1))

Title โ”€โ”€โ”€โ”€โ”€

Centered text in cell

REPT LEN

Put text in A1 and total width in B1. Pads with spaces to center.

=REPT(" ",MAX(0,INT((B1-LEN(A1))/2)))&A1

Hello

Right-aligned text in cell

REPT LEN

Put text in A1 and total width in B1. Pads with spaces on the left.

=REPT(" ",MAX(0,B1-LEN(A1)))&A1

Hi

Section title with rules

REPT CHAR

Put section width in A1 and title in B1. Heavy rules above and below.

=REPT("โ•",A1)&CHAR(10)&B1&CHAR(10)&REPT("โ•",A1)

โ•โ•โ•โ•โ•โ•โ•โ• Notes โ•โ•โ•โ•โ•โ•โ•โ•

Table row with pipes

LEN

Put values in A1, B1, and C1. One pipe-separated table row.

="| "&A1&" | "&B1&" | "&C1&" |"

| Name | Qty | Price |

Table column header line

LEN REPT CHAR

Put header text in A1. Top border with side stems.

="โ”œ"&REPT("โ”€",LEN(A1)+2)&"โ”ค"&CHAR(10)&"โ”‚ "&A1&" โ”‚"

โ”œโ”€โ”€โ”€โ”€โ”€โ”ค โ”‚ Qty โ”‚

Grid top border

REPT

Put left column width in A1 and right column width in B1. Two-column table top.

="โ”Œ"&REPT("โ”€",A1)&"โ”ฌ"&REPT("โ”€",B1)&"โ”"

โ”Œโ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”

Grid middle row

REPT

Put left column width in A1 and right column width in B1. Row separator for two columns.

="โ”œ"&REPT("โ”€",A1)&"โ”ผ"&REPT("โ”€",B1)&"โ”ค"

โ”œโ”€โ”€โ”€โ”ผโ”€โ”€โ”€โ”ค

Left T divider

REPT

Put half-width in A1. Horizontal line with a left stem.

=REPT("โ”€",A1)&"โ”œ"&REPT("โ”€",A1)

โ”€โ”€โ”€โ”€โ”œโ”€โ”€โ”€โ”€

Right T divider

REPT

Put half-width in A1. Horizontal line with a right stem.

=REPT("โ”€",A1)&"โ”ค"&REPT("โ”€",A1)

โ”€โ”€โ”€โ”€โ”คโ”€โ”€โ”€โ”€

L-shaped corner

REPT

Put arm length in A1. Bottom-left corner piece for manual tables.

="โ””"&REPT("โ”€",A1)

โ””โ”€โ”€โ”€โ”€

Three-line menu icon

REPT CHAR

Put bar width in A1. Stacked horizontal bars. Turn on Wrap text.

=REPT("โ•",A1)&CHAR(10)&REPT("โ•",A1)&CHAR(10)&REPT("โ•",A1)

โ•โ•โ• โ•โ•โ• โ•โ•โ•

Bracket label wrap

LEN

Put label text in A1. Wraps it in square brackets.

="["&" "&A1&" "&"]"

[ Hello ]

Curly quote wrap

CHAR

Put quote text in A1. Wraps it in curly double quotes.

=CHAR(8220)&A1&CHAR(8221)

โ€œHelloโ€

Ellipsis truncate

IF LEN LEFT

Put text in A1 and max length in B1. Adds ... when text is too long.

=IF(LEN(A1)>B1,LEFT(A1,B1-3)&"...",A1)

Long sentence...

Box border cell

REPT CHAR

Put inner width in A1. Draws a box around empty space.

="โ”Œ"&REPT("โ”€",A1)&"โ”"&CHAR(10)&"โ”‚"&REPT(" ",A1)&"โ”‚"&CHAR(10)&"โ””"&REPT("โ”€",A1)&"โ”˜"

โ”Œโ”€โ”€โ”€โ”€โ” โ”‚ โ”‚ โ””โ”€โ”€โ”€โ”€โ”˜

Surround by ASCII

REPT LEN CHAR

Put text in A1. Double-line top and bottom with text between.

=CHAR(9556)&REPT(CHAR(9552),LEN(A1)+2)&CHAR(9559)&CHAR(10)&A1&CHAR(10)&CHAR(9562)&REPT(CHAR(9552),LEN(A1)+2)&CHAR(9565)

โ•”โ•โ•โ•โ•โ•โ•โ•โ•— Hello โ•šโ•โ•โ•โ•โ•โ•โ•โ•

Rounded border cell

REPT CHAR

Put inner width in A1. Box with rounded corners.

="โ•ญ"&REPT("โ”€",A1)&"โ•ฎ"&CHAR(10)&"โ”‚"&REPT(" ",A1)&"โ”‚"&CHAR(10)&"โ•ฐ"&REPT("โ”€",A1)&"โ•ฏ"

โ•ญโ”€โ”€โ”€โ”€โ•ฎ โ”‚ โ”‚ โ•ฐโ”€โ”€โ”€โ”€โ•ฏ

Heavy border cell

REPT CHAR

Put inner width in A1. Thick box-drawing characters.

="โ”"&REPT("โ”",A1)&"โ”“"&CHAR(10)&"โ”ƒ"&REPT(" ",A1)&"โ”ƒ"&CHAR(10)&"โ”—"&REPT("โ”",A1)&"โ”›"

โ”โ”โ”โ”โ”โ”“ โ”ƒ โ”ƒ โ”—โ”โ”โ”โ”โ”›

Text inside box

LEN REPT CHAR

Put text in A1. Light border with side bars on the text row.

="โ”Œ"&REPT("โ”€",LEN(A1)+2)&"โ”"&CHAR(10)&"โ”‚ "&A1&" โ”‚"&CHAR(10)&"โ””"&REPT("โ”€",LEN(A1)+2)&"โ”˜"

โ”Œโ”€โ”€โ”€โ”€โ” โ”‚ Hi โ”‚ โ””โ”€โ”€โ”€โ”€โ”˜

Text inside double box

LEN REPT CHAR

Put text in A1. Double-line border with sides on the text row.

="โ•”"&REPT("โ•",LEN(A1)+2)&"โ•—"&CHAR(10)&"โ•‘ "&A1&" โ•‘"&CHAR(10)&"โ•š"&REPT("โ•",LEN(A1)+2)&"โ•"

โ•”โ•โ•โ•โ•โ•โ•โ•โ•— โ•‘ Hello โ•‘ โ•šโ•โ•โ•โ•โ•โ•โ•โ•

Header box

LEN REPT CHAR

Put label text in A1. Top and side borders with no bottom row.

="โ”"&REPT("โ”",LEN(A1)+2)&"โ”“"&CHAR(10)&"โ”ƒ "&A1&" โ”ƒ"

โ”โ”โ”โ”โ”โ”โ”โ”โ”“ โ”ƒ Title โ”ƒ

Side border panel

REPT CHAR

Put width in A1 and height in B1. Open panel with left and right bars only.

=REPT("โ”‚"&REPT(" ",A1)&"โ”‚"&CHAR(10),B1-1)&"โ”‚"&REPT(" ",A1)&"โ”‚"

โ”‚ โ”‚ โ”‚ โ”‚ โ”‚ โ”‚

Horizontal rule

REPT

Put width in A1. Single row of light dashes.

=REPT("โ”€",A1)

โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€

Dashed horizontal rule

REPT

Put width in A1. Dotted horizontal line.

=REPT("โ”„",A1)

โ”„โ”„โ”„โ”„โ”„โ”„โ”„โ”„

Vertical divider

REPT CHAR

Put height in A1. Stack light vertical bars. Turn on Wrap text.

=REPT("โ”‚"&CHAR(10),A1-1)&"โ”‚"

โ”‚ โ”‚ โ”‚ โ”‚

T-section divider

REPT

Put half-width in A1. Horizontal line with a center stem.

=REPT("โ”€",A1)&"โ”ฌ"&REPT("โ”€",A1)

โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€

Cross divider

REPT

Put half-width in A1. Horizontal line with a center cross.

=REPT("โ”€",A1)&"โ”ผ"&REPT("โ”€",A1)

โ”€โ”€โ”€โ”€โ”ผโ”€โ”€โ”€โ”€

ASCII billboard

LEN REPT CHAR

Put message in A1. Framed sign with a centered peg underneath.

="โ”Œ"&REPT("โ”€",LEN(A1)+2)&"โ”"&CHAR(10)&"โ”‚ "&A1&" โ”‚"&CHAR(10)&"โ””"&REPT("โ”€",INT((LEN(A1)+2)/2))&"โ”ด"&REPT("โ”€",LEN(A1)+2-INT((LEN(A1)+2)/2)-1)&"โ”˜"&CHAR(10)&REPT(" ",1+INT((LEN(A1)+2)/2))&"โ”‚"&CHAR(10)&REPT(" ",1+INT((LEN(A1)+2)/2))&"โ”‚"

โ”Œโ”€โ”€โ”€โ”€โ”€โ”€โ” โ”‚ SALE โ”‚ โ””โ”€โ”€โ”€โ”ดโ”€โ”€โ”˜ โ”‚ โ”‚

Goal posts

LEN REPT CHAR

Put label in A1. Upright posts with a crossbar and your word between.

=" โ”‚"&REPT(" ",LEN(A1)+4)&"โ”‚"&CHAR(10)&" โ”‚"&REPT(" ",LEN(A1)+4)&"โ”‚"&CHAR(10)&" โ”‚ "&A1&REPT(" ",LEN(A1)+4-LEN(A1)-1)&"โ”‚"&CHAR(10)&"โ”€โ”ด"&REPT("โ”€",LEN(A1)+4)&"โ”ดโ”€"

โ”‚ โ”‚ โ”‚ โ”‚ โ”‚ GOAL โ”‚ โ”€โ”ดโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ดโ”€

Hanging sign

LEN REPT CHAR

Put shop name in A1. Two posts above with a sign hanging below.

="โ”‚"&REPT(" ",LEN(A1)+14)&"โ”‚"&CHAR(10)&"โ•ฐ"&REPT("โ”€",INT((LEN(A1)+14)/2))&"โ”ฌ"&REPT("โ”€",LEN(A1)+14-INT((LEN(A1)+14)/2))&"โ•ฏ"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2))&"โ”‚"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2)-INT((LEN(A1)+6)/2))&"โ”Œ"&REPT("โ”€",INT((LEN(A1)+2)/2))&"โ”ด"&REPT("โ”€",LEN(A1)+2-INT((LEN(A1)+2)/2))&"โ”"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2)-INT((LEN(A1)+6)/2))&"โ”‚ "&A1&" โ”‚"&CHAR(10)&REPT(" ",INT((LEN(A1)+16)/2)-INT((LEN(A1)+6)/2))&"โ””"&REPT("โ”€",LEN(A1)+2)&"โ”˜"

โ”‚ โ”‚ โ•ฐโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”ฌโ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ•ฏ โ”‚ โ”Œโ”€โ”€โ”€โ”ดโ”€โ”€โ”€โ” โ”‚ OPEN โ”‚ โ””โ”€โ”€โ”€โ”€โ”€โ”€โ”˜

Sparkline blocks

REPT

Put a score 0-10 in A1. Mini bar chart in one cell.

=REPT("โ–ˆ",A1)&REPT("โ–",10-A1)

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–โ–โ–โ–โ–

Mood faces

CHOOSE

Put mood 1-5 in A1. 1 is sad, 5 is happy.

=CHOOSE(A1,"๐Ÿ˜ข","๐Ÿ˜•","๐Ÿ˜","๐Ÿ™‚","๐Ÿ˜„")

๐Ÿ™‚

Password strength

REPT IF

Put strength 0-5 in A1. Labels Weak, OK, or Strong.

=REPT("โ–ˆ",A1)&REPT("โ–‘",5-A1)&" "&IF(A1>=4,"Strong",IF(A1>=2,"OK","Weak"))

โ–ˆโ–ˆโ–ˆโ–‘โ–‘ OK

Tree growth stages

CHOOSE MIN

Put stage 1-4 in A1. Seedling grows into a tree.

=CHOOSE(MIN(A1,4),"๐ŸŒฑ","๐ŸŒฟ","๐ŸŒณ","๐ŸŒฒ","๐ŸŒฒ")

๐ŸŒณ

Growth completion by percentage

IF CHOOSE

Put completion 0-100 in A1. Grows every 25%.

=CHOOSE(IF(A1>=100,5,IF(A1>75,4,IF(A1>50,3,IF(A1>25,2,1)))),"๐ŸŒฑ","๐ŸŒฟ","๐ŸŒณ","๐ŸŒฒ","๐ŸŒฒ")

๐ŸŒฑ๐ŸŒฟ๐ŸŒณ๐ŸŒฒ๐ŸŒฒ

Arrow compass

CHOOSE

Put direction 1-8 in A1. Clockwise from north.

=CHOOSE(A1,"โ†‘","โ†—","โ†’","โ†˜","โ†“","โ†™","โ†","โ†–")

โ†’

Compass direction arrows

SWITCH CHAR

Put a direction in A1: North, South, East, West, or diagonals like North East.

=SWITCH(A1,"North",CHAR(8593),"North East",CHAR(8599),"East",CHAR(8594),"South East",CHAR(8600),"South",CHAR(8595),"South West",CHAR(8601),"West",CHAR(8592),"North West",CHAR(8598))

North โ†’ โ†‘

Snail race to finish

REPT MAX

Put lap position 0-10 in A1. Snail crawls toward the checkered flag.

=REPT("ยท",A1)&"๐ŸŒ"&REPT("ยท",MAX(0,10-A1))&"๐Ÿ"

ยทยทยท๐ŸŒยทยทยทยทยทยท๐Ÿ

Poop races to the toilet

REPT MAX

Put checked count 0-10 in A1. Each check pulls ๐Ÿ’ฉ closer to ๐Ÿšฝ.

=REPT("ยท",A1)&"๐Ÿ’ฉ"&REPT("ยท",MAX(0,10-A1))&"๐Ÿšฝ"

ยทยทยท๐Ÿ’ฉยทยทยทยทยทยทยท๐Ÿšฝ

Rocket launch pad

REPT MAX CHAR

Higher A1 adds more flame blocks under the rocket.

=REPT("ยท",MAX(0,8-A1))&"๐Ÿš€"&REPT(CHAR(9650),A1)

ยทยทยทยทยท๐Ÿš€โ–ฒโ–ฒโ–ฒ

Fire intensity meter

REPT

Put intensity 0-5 in A1.

=REPT("๐Ÿ”ฅ",A1)&REPT("โ—‹",5-A1)

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโ—‹โ—‹

Coffee cup counter

REPT

Put cups drunk 0-5 in A1.

=REPT("โ˜•",A1)&REPT("โ—‹",5-A1)

โ˜•โ˜•โ˜•โ—‹โ—‹

Pizza slice tracker

REPT

Put slices left in A1.

=REPT("๐Ÿ•",A1)&" left"

๐Ÿ•๐Ÿ•๐Ÿ• left

Ice cream scoops

REPT

Put scoop count 0-5 in A1.

=REPT("๐Ÿฆ",A1)&REPT("ยท",5-A1)

๐Ÿฆ๐Ÿฆ๐Ÿฆยทยท

Hearts counter

REPT

Put love level 0-5 in A1. Filled red hearts show the score.

=REPT("โค๏ธ",A1)&REPT("๐Ÿค",5-A1)

โค๏ธโค๏ธโค๏ธ๐Ÿค๐Ÿค

Mending hearts counter

REPT IF

Put love level 0-5 in A1. Score 1 is broken, 2-3 mending, 4-5 full hearts.

=IF(A1<=0,REPT("๐Ÿค",5),IF(A1=1,REPT("๐Ÿ’”",1)&REPT("๐Ÿค",4),IF(A1<=3,REPT("โค๏ธโ€๐Ÿฉน",A1)&REPT("๐Ÿค",5-A1),REPT("โค๏ธ",A1)&REPT("๐Ÿค",5-A1))))

โค๏ธโ€๐Ÿฉนโค๏ธโ€๐Ÿฉน๐Ÿค๐Ÿค๐Ÿค

Hearts white to red counter

IF

Put love level 0-5 in A1. Each slot turns from white to red as the score rises.

=IF(A1>=1,"โค๏ธ","๐Ÿค")&IF(A1>=2,"โค๏ธ","๐Ÿค")&IF(A1>=3,"โค๏ธ","๐Ÿค")&IF(A1>=4,"โค๏ธ","๐Ÿค")&IF(A1>=5,"โค๏ธ","๐Ÿค")

โค๏ธโค๏ธโค๏ธ๐Ÿค๐Ÿค

Rainbow hearts counter

IF

Put love level 0-5 in A1. Each filled heart gets its own color.

=IF(A1>=1,"โค๏ธ","๐Ÿค")&IF(A1>=2,"๐Ÿงก","๐Ÿค")&IF(A1>=3,"๐Ÿ’›","๐Ÿค")&IF(A1>=4,"๐Ÿ’š","๐Ÿค")&IF(A1>=5,"๐Ÿ’™","๐Ÿค")

โค๏ธ๐Ÿงก๐Ÿ’›๐Ÿค๐Ÿค

Taco Tuesday count

REPT

Put taco count in A1.

=REPT("๐ŸŒฎ",A1)

๐ŸŒฎ๐ŸŒฎ๐ŸŒฎ

Taco Rating

REPT

Put rating 1-5 in A1.

=REPT("๐ŸŒฎ",A1)&" out of 5"

๐ŸŒฎ๐ŸŒฎ๐ŸŒฎ๐ŸŒฎ๐ŸŒฎ out of 5

Sushi plate rating

REPT

Put rating 0-5 in A1.

=REPT("๐Ÿฃ",A1)&REPT("โ—‹",5-A1)

๐Ÿฃ๐Ÿฃ๐Ÿฃโ—‹โ—‹

Colored book rating

REPT

Put rating 0-5 in A1. Closed books fill the row.

=REPT("๐Ÿ“•",A1)&REPT("๐Ÿ“–",5-A1)

๐Ÿ“•๐Ÿ“•๐Ÿ“•๐Ÿ“–๐Ÿ“–

Book stack rating

REPT

Put rating 0-5 in A1. Stacks for filled, single books for empty.

=REPT("๐Ÿ“š",A1)&REPT("๐Ÿ“•",5-A1)

๐Ÿ“š๐Ÿ“š๐Ÿ“š๐Ÿ“•๐Ÿ“•

Fire rating

REPT

Put rating 0-5 in A1. More fire, hotter the score.

=REPT("๐Ÿ”ฅ",A1)&REPT("โ—‹",5-A1)

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโ—‹โ—‹

Coffee rating

REPT

Put rating 0-5 in A1. Cups show how strong the brew is.

=REPT("โ˜•",A1)&REPT("โ—‹",5-A1)

โ˜•โ˜•โ˜•โ—‹โ—‹

Thumbs up rating

REPT

Put rating 0-5 in A1. Thumbs up for every point scored.

=REPT("๐Ÿ‘",A1)&REPT("โ—‹",5-A1)

๐Ÿ‘๐Ÿ‘๐Ÿ‘โ—‹โ—‹

Thumbs up and down rating

REPT

Put rating 0-5 in A1. Thumbs up for score, thumbs down for the rest.

=REPT("๐Ÿ‘",A1)&REPT("๐Ÿ‘Ž",5-A1)

๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿ‘Ž๐Ÿ‘Ž

Skull rating

REPT

Put rating 0-5 in A1. Skulls mark the danger level.

=REPT("๐Ÿ’€",A1)&REPT("โ—‹",5-A1)

๐Ÿ’€๐Ÿ’€๐Ÿ’€โ—‹โ—‹

Hot dog and donut rating

IF

Put 0 or 1 in A1. Donut for zero, hot dog for one.

=IF(A1=1,"๐ŸŒญ","๐Ÿฉ")

๐ŸŒญ

Green apple go / red apple no

IF LOWER OR

Put yes, no, go, or stop in A1. Green apple for go, red apple for no.

=IF(OR(LOWER(A1)="yes",LOWER(A1)="go"),"๐Ÿ",IF(OR(LOWER(A1)="no",LOWER(A1)="stop"),"๐ŸŽ","๐Ÿคท"))

๐Ÿ

Chess rank badge

CHOOSE CHAR

Put rank 1-6 in A1: pawn through king.

=CHOOSE(A1,CHAR(9823),CHAR(9822),CHAR(9821),CHAR(9820),CHAR(9819),CHAR(9818))

โ™›

Playing card suit

CHOOSE CHAR

Put 1-4 in A1 for spade, heart, diamond, or club.

=CHOOSE(A1,CHAR(9824),CHAR(9829),CHAR(9830),CHAR(9827))

โ™ 

Gold bar vault

REPT CHAR

Put gold level 0-5 in A1. Block shading shows fill.

=REPT(CHAR(9619),A1)&REPT(CHAR(9617),5-A1)

โ–“โ–“โ–“โ–‘โ–‘

Wifi signal bars

REPT CHOOSE CHAR

Put signal strength 1-5 in A1.

=CHOOSE(A1,CHAR(9601),CHAR(9601)&CHAR(9602),CHAR(9604)&CHAR(9605),CHAR(9606)&CHAR(9607),REPT(CHAR(9608),4))

โ–„โ–…

Pin map journey

REPT MAX

Put progress 0-10 in A1. Pin travels toward home.

=REPT("ยท",A1)&"๐Ÿ“"&REPT("ยท",MAX(0,10-A1))&"๐Ÿ "

ยทยทยท๐Ÿ“ยทยทยทยท๐Ÿ 

Ship sailing home

REPT MAX

Put progress 0-8 in A1. Boat sails across wave emojis.

=REPT("๐ŸŒŠ",A1)&"โ›ต"&REPT("๐ŸŒŠ",MAX(0,8-A1))

๐ŸŒŠ๐ŸŒŠ๐ŸŒŠโ›ต๐ŸŒŠ๐ŸŒŠ๐ŸŒŠ๐ŸŒŠ

Clap-o-meter

REPT

Put applause count in A1.

=REPT("๐Ÿ‘",A1)

๐Ÿ‘๐Ÿ‘๐Ÿ‘

Trophy shelf

REPT CHAR

Put trophies won 0-5 in A1. Empty slots show outline stars.

=REPT("๐Ÿ†",A1)&REPT(CHAR(9734),5-A1)

๐Ÿ†๐Ÿ†โ˜†โ˜†โ˜†

Moon phase picker

CHOOSE

Put phase 1-8 in A1 for the lunar cycle.

=CHOOSE(A1,"๐ŸŒ‘","๐ŸŒ’","๐ŸŒ“","๐ŸŒ”","๐ŸŒ•","๐ŸŒ–","๐ŸŒ—","๐ŸŒ˜")

๐ŸŒ“

Moon phase by name

SWITCH LOWER

Put a phase name in A1: new, waxing crescent, first quarter, waxing gibbous, full, waning gibbous, last quarter, or waning crescent.

=SWITCH(LOWER(A1),"new","๐ŸŒ‘","waxing crescent","๐ŸŒ’","first quarter","๐ŸŒ“","waxing gibbous","๐ŸŒ”","full","๐ŸŒ•","waning gibbous","๐ŸŒ–","last quarter","๐ŸŒ—","waning crescent","๐ŸŒ˜","๐ŸŒ‘")

๐ŸŒ•

Chicken life cycle

CHOOSE

Put stage 1-4 in A1. Egg hatches into a hen.

=CHOOSE(A1,"๐Ÿฅš","๐Ÿฃ","๐Ÿค","๐Ÿ”")

๐Ÿค

Butterfly metamorphosis

CHOOSE

Put stage 1-4 in A1. Egg, caterpillar, cocoon, butterfly.

=CHOOSE(A1,"๐Ÿฅš","๐Ÿ›","๐Ÿ›Œ","๐Ÿฆ‹")

๐Ÿฆ‹

Dragon hatching

CHOOSE

Put stage 1-4 in A1. Egg cracks into a full dragon.

=CHOOSE(A1,"๐Ÿฅš","๐Ÿฃ","๐Ÿฒ","๐Ÿ‰")

๐Ÿฒ

Storm brewing phases

CHOOSE

Put intensity 1-5 in A1. Clear sky builds into a thunderstorm.

=CHOOSE(A1,"โ˜€๏ธ","๐ŸŒค๏ธ","๐ŸŒฅ๏ธ","๐ŸŒง๏ธ","โ›ˆ๏ธ")

๐ŸŒง๏ธ

Four seasons

CHOOSE

Put season 1-4 in A1. Spring, summer, fall, winter.

=CHOOSE(A1,"๐ŸŒธ","โ˜€๏ธ","๐Ÿ‚","โ„๏ธ")

๐Ÿ‚

Day arc phases

CHOOSE

Put hour block 1-6 in A1. Night, sunrise, midday, afternoon, sunset, moon.

=CHOOSE(A1,"๐ŸŒƒ","๐ŸŒ…","โ˜€๏ธ","๐ŸŒค๏ธ","๐ŸŒ‡","๐ŸŒ™")

๐ŸŒ‡

Water cycle phases

CHOOSE

Put phase 1-4 in A1. Ocean, evaporation, cloud, rain.

=CHOOSE(A1,"๐ŸŒŠ","โ˜€๏ธ","โ˜๏ธ","๐ŸŒง๏ธ")

โ˜๏ธ

Project lifecycle

CHOOSE

Put stage 1-5 in A1. Idea, plan, build, ship, celebrate.

=CHOOSE(A1,"๐Ÿ’ก","๐Ÿ“","๐Ÿ”จ","โœ…","๐ŸŽ‰")

๐Ÿ”จ

Treasure hunt story

CHOOSE

Put step 1-5 in A1. Map, sail, island, dig, gold.

=CHOOSE(A1,"๐Ÿ—บ๏ธ","โ›ต","๐Ÿ๏ธ","๐Ÿ•ณ๏ธ","๐Ÿ’ฐ")

๐Ÿ๏ธ

Campfire growth

CHOOSE

Put stage 1-4 in A1. Wood, spark, fire, campsite.

=CHOOSE(A1,"๐Ÿชต","โœจ","๐Ÿ”ฅ","๐Ÿ•๏ธ")

๐Ÿ”ฅ

Soup cooking story

CHOOSE

Put step 1-4 in A1. Chop veggies, simmer pot, serve bowl, enjoy.

=CHOOSE(A1,"๐Ÿฅ•","๐Ÿฒ","๐Ÿฅฃ","๐Ÿ˜‹")

๐Ÿฒ

Pizza baking stages

CHOOSE

Put stage 1-4 in A1. Dough, toppings, oven, slice.

=CHOOSE(A1,"๐Ÿซ“","๐Ÿง€","๐Ÿ•","๐Ÿ˜‹")

๐Ÿ•

Snowman building

CHOOSE

Put step 1-4 in A1. Snow, body, scarf, finished snowman.

=CHOOSE(A1,"โ„๏ธ","โ›„","๐Ÿงฃ","โ˜ƒ๏ธ")

โ›„

Book reading progress

CHOOSE

Put progress 1-4 in A1. Closed, reading, almost done, finished.

=CHOOSE(A1,"๐Ÿ“•","๐Ÿ“–","๐Ÿ“—","โœ…")

๐Ÿ“–

Rocket launch story

CHOOSE

Put step 1-5 in A1. Prep, fuel, launch, blastoff, orbit.

=CHOOSE(A1,"๐Ÿ”ง","โ›ฝ","๐Ÿš€","๐Ÿ”ฅ","๐ŸŒŒ")

๐Ÿš€

Cat affection levels

CHOOSE

Put level 1-4 in A1. Grumpy, curious, happy, loving.

=CHOOSE(A1,"๐Ÿ˜พ","๐Ÿ˜ผ","๐Ÿ˜ธ","๐Ÿ˜ป")

๐Ÿ˜ธ

Sick to well recovery

CHOOSE

Put stage 1-5 in A1. Sniffles, fever, medicine, doctor, healthy.

=CHOOSE(A1,"๐Ÿคง","๐Ÿค’","๐Ÿ’Š","๐Ÿฉบ","๐Ÿ˜Š")

๐Ÿ’Š

Ocean depth zones

CHOOSE

Put depth level 1-5 in A1. Beach, reef, deep sea, shark zone, trench.

=CHOOSE(A1,"๐Ÿ–๏ธ","๐Ÿ ","๐Ÿ™","๐Ÿฆˆ","๐ŸŒ‘")

๐Ÿ™

Fitness rank badges

CHOOSE

Put rank 1-4 in A1. Bronze, silver, gold, champion.

=CHOOSE(A1,"๐Ÿฅ‰","๐Ÿฅˆ","๐Ÿฅ‡","๐Ÿ†")

๐Ÿฅ‡

Umbrella rain test

IF

Put rainfall percent in A1. Over 50 shows wet.

=IF(A1>50,"โ˜” Wet","โ˜€ Dry")

โ˜” Wet

Wind gust strength

REPT

Put wind level 0-5 in A1.

=REPT("๐Ÿ’จ",A1)&REPT("ยท",5-A1)

๐Ÿ’จ๐Ÿ’จ๐Ÿ’จยทยท

Snowfall depth

REPT

Put snow depth 0-10 in A1.

=REPT("โ„",A1)&REPT("ยท",10-A1)

โ„โ„โ„โ„ยทยทยทยทยทยทยท

Thermometer strip

REPT CHAR

Put temperature in A1. Shows a 10-block strip plus degrees.

=REPT(CHAR(9619),A1)&REPT(CHAR(9617),10-A1)&" "&A1&CHAR(176)

โ–“โ–“โ–“โ–“โ–“โ–‘โ–‘โ–‘โ–‘โ–‘ 72ยฐ

Hourglass flip

IF MOD CHAR

Even numbers show one hourglass, odd numbers the other.

=IF(MOD(A1,2)=0,CHAR(9203),CHAR(8987))

โณ

Alarm clock urgency

REPT

Put alarm count in A1. More clocks, louder wake-up.

=REPT("โฐ",A1)&" Wake up!"

โฐโฐ Wake up!

Alarm hour match

IF HOUR NOW REPT

Put target hour 0-23 in A1 (24-hour clock). Rings when the current hour matches.

=IF(HOUR(NOW())=A1,REPT("โฐ",3)&" Wake up!","๐Ÿ’ค Sleeping")

โฐโฐโฐ Wake up!

Birthday candle count

REPT

Put age or candle count in A1.

=REPT("๐Ÿ•ฏ",A1)&"๐ŸŽ‚"

๐Ÿ•ฏ๐Ÿ•ฏ๐Ÿ•ฏ๐ŸŽ‚

Christmas star tree

REPT MAX CHAR

Put decoration level 0-8 in A1. Stars lead to the tree.

=REPT(CHAR(9733),A1)&"๐ŸŽ„"&REPT("ยท",MAX(0,8-A1))

โ˜…โ˜…โ˜…๐ŸŽ„ยทยทยทยทยท

Halloween pumpkin row

REPT MIN

Put pumpkin count in A1. Caps at five.

=REPT("๐ŸŽƒ",MIN(A1,5))

๐ŸŽƒ๐ŸŽƒ๐ŸŽƒ

Easter egg hunt

REPT

Put eggs found 0-5 in A1.

=REPT("๐Ÿฅš",A1)&REPT("๐ŸŒฟ",5-A1)

๐Ÿฅš๐Ÿฅš๐Ÿฅš๐ŸŒฟ๐ŸŒฟ

Football field push

REPT CHAR

Put yards gained 0-10 in A1. Ball advances downfield.

=REPT(CHAR(9619),A1)&"๐Ÿˆ"&REPT(CHAR(9617),10-A1)

โ–“โ–“โ–“๐Ÿˆโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Basketball shots made

REPT

Put shots made 0-5 in A1.

=REPT("๐Ÿ€",A1)&REPT("โ—‹",5-A1)

๐Ÿ€๐Ÿ€๐Ÿ€โ—‹โ—‹

Tennis rally counter

REPT

Put rally count in A1.

=REPT("๐ŸŽพ",A1)

๐ŸŽพ๐ŸŽพ๐ŸŽพ

Swimming lap tracker

REPT

Put lap count in A1. Swimmer plus wave marks.

=REPT("๐ŸŠ",1)&REPT("ใ€ฐ",A1)

๐ŸŠใ€ฐใ€ฐใ€ฐ

Yoga calm meter

REPT

Put calm level in A1. Peace sign at the end.

=REPT("๐Ÿง˜",1)&REPT("ยท",A1)&REPT("โ˜ฎ",1)

๐Ÿง˜ยทยทยทโ˜ฎ

Reading page progress

REPT

Put pages read 0-5 in A1.

=REPT("๐Ÿ“–",A1)&REPT("๐Ÿ“•",5-A1)

๐Ÿ“–๐Ÿ“–๐Ÿ“–๐Ÿ“•๐Ÿ“•

Email inbox pile

REPT

Put unread count in A1.

=REPT("๐Ÿ“ง",A1)&" unread"

๐Ÿ“ง๐Ÿ“ง๐Ÿ“ง unread

Piggy bank savings

REPT

Put coin count in A1.

=REPT("๐Ÿท",1)&REPT("๐Ÿ’ฐ",A1)

๐Ÿท๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ

Light bulb ideas

REPT

Put idea count 0-5 in A1.

=REPT("๐Ÿ’ก",A1)&REPT("โ—‹",5-A1)

๐Ÿ’ก๐Ÿ’ก๐Ÿ’กโ—‹โ—‹

Music note volume

REPT MAX CHAR

Put note count in A1. Quarter and eighth notes.

=REPT(CHAR(9834),A1)&REPT(CHAR(9835),MAX(0,3-A1))

โ™ชโ™ชโ™ชโ™ซ

Guitar solo intensity

REPT CHAR

Put solo intensity in A1.

=REPT("๐ŸŽธ",1)&REPT(CHAR(9834),A1)

๐ŸŽธโ™ชโ™ชโ™ช

Karaoke mic level

REPT CHAR

Put mic level 0-5 in A1. Block meter beside the mic.

=REPT("๐ŸŽค",1)&REPT(CHAR(9601),A1)&REPT(CHAR(9608),5-A1)

๐ŸŽคโ–โ–โ–ˆโ–ˆโ–ˆ

Popcorn movie rating

REPT CHAR

Put rating 0-5 in A1. Popcorn plus star row.

=REPT("๐Ÿฟ",1)&REPT(CHAR(9733),A1)&REPT(CHAR(9734),5-A1)

๐Ÿฟโ˜…โ˜…โ˜…โ˜†โ˜†

Game controller lives

REPT

Put lives left 0-3 in A1.

=REPT("๐ŸŽฎ",A1)&REPT("โœ—",3-A1)

๐ŸŽฎ๐ŸŽฎ๐ŸŽฎ

Puzzle pieces solved

REPT

Put pieces placed in A1.

=REPT("๐Ÿงฉ",A1)&REPT("โ–ก",9-A1)

๐Ÿงฉ๐Ÿงฉ๐Ÿงฉโ–กโ–กโ–กโ–กโ–กโ–ก

Slot machine cherries

REPT

Put match count in A1. Cherries vs lemons.

=REPT("๐Ÿ’",A1)&REPT("๐Ÿ‹",3-A1)

๐Ÿ’๐Ÿ’๐Ÿ‹

Dragon HP bar

REPT MIN MAX CHAR

Put hit points 0-10 in A1.

=REPT(CHAR(9829),MIN(A1,5))&REPT(CHAR(9608),MAX(0,A1-5))&REPT(CHAR(9617),10-A1)&" ๐Ÿ‰"

โ™ฅโ™ฅโ–ˆโ–‘โ–‘ ๐Ÿ‰

Wizard sparkle level

REPT

Put magic level in A1.

=REPT("๐Ÿง™",1)&REPT("โœจ",A1)

๐Ÿง™โœจโœจโœจ

Castle wall defense

REPT CHAR

Put wall strength 0-10 in A1. Solid blocks build up to the castle.

=REPT(CHAR(9608),A1)&"๐Ÿฐ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿฐโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Fence perimeter defense

REPT CHAR

Put fence strength 0-10 in A1. Blocks stack toward the barrier.

=REPT(CHAR(9608),A1)&"๐Ÿšง"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿšงโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Home fortification

REPT CHAR

Put fortify progress 0-10 in A1. Wall builds toward home.

=REPT(CHAR(9608),A1)&"๐Ÿ "&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿ โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Forest tree line

REPT CHAR

Put clearance 0-10 in A1. Cleared path reaches the tree line.

=REPT(CHAR(9608),A1)&"๐ŸŒฒ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐ŸŒฒโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Bank vault barrier

REPT CHAR

Put security level 0-10 in A1. Dark blocks seal the vault.

=REPT(CHAR(9619),A1)&"๐Ÿฆ"&REPT(CHAR(9617),10-A1)

โ–“โ–“โ–“๐Ÿฆโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Brick wall gate

REPT CHAR

Put build progress 0-10 in A1. Bricks stack toward the gate.

=REPT("๐Ÿงฑ",A1)&"๐Ÿšช"&REPT(CHAR(9617),10-A1)

๐Ÿงฑ๐Ÿงฑ๐Ÿงฑ๐Ÿšชโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Garden fence gate

REPT CHAR

Put fence progress 0-10 in A1. Blocks reach the garden gate.

=REPT(CHAR(9608),A1)&"๐ŸŒท"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐ŸŒทโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Camp perimeter wall

REPT CHAR

Put camp defense 0-10 in A1. Wall closes in on the tent.

=REPT(CHAR(9608),A1)&"โ›บ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆโ›บโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Treasure hoard guard

REPT CHAR

Put guard level 0-10 in A1. Blocks protect the gold.

=REPT(CHAR(9608),A1)&"๐Ÿ’ฐ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿ’ฐโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Soccer goal defense

REPT CHAR

Put defense rating 0-10 in A1. Back line holds the goal.

=REPT(CHAR(9608),A1)&"๐Ÿฅ…"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿฅ…โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Beehive barrier

REPT CHAR

Put hive defense 0-10 in A1. Wall shields the honey.

=REPT(CHAR(9608),A1)&"๐Ÿฏ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿฏโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Harbor dock wall

REPT CHAR

Put dock progress 0-10 in A1. Pier builds toward the anchor.

=REPT(CHAR(9608),A1)&"โš“"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆโš“โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Barn paddock fence

REPT CHAR

Put fence progress 0-10 in A1. Rails close around the barn.

=REPT(CHAR(9608),A1)&"๐Ÿ„"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿ„โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Hospital ward barrier

REPT CHAR

Put safety level 0-10 in A1. Barrier reaches the ward.

=REPT(CHAR(9608),A1)&"๐Ÿฅ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿฅโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

School yard fence

REPT CHAR

Put fence progress 0-10 in A1. Wall rings the school.

=REPT(CHAR(9608),A1)&"๐Ÿซ"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿซโ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Space base shield

REPT CHAR

Put shield strength 0-10 in A1. Blocks protect the rocket.

=REPT(CHAR(9608),A1)&"๐Ÿš€"&REPT(CHAR(9617),10-A1)

โ–ˆโ–ˆโ–ˆ๐Ÿš€โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘โ–‘

Seed to sunflower

CHOOSE

Put growth stage 1-5 in A1.

=CHOOSE(A1,"๐ŸŒฐ","๐ŸŒฑ","๐ŸŒฟ","๐ŸŒป","๐ŸŒป")

๐ŸŒป

Wood to fire to ash

IF REPT

Put burn progress 0-10 in A1. Logs catch fire, then cool to gray ash.

=IF(A1<=3,REPT("๐Ÿชต",A1)&REPT("โ–‘",10-A1),IF(A1<=7,REPT("๐Ÿชต",3)&REPT("๐Ÿ”ฅ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿชต",3)&REPT("๐Ÿ”ฅ",4)&REPT("โฌ›",A1-7)&REPT("โ–‘",10-A1)))

๐Ÿชต๐Ÿชต๐Ÿชต๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโฌ›โฌ›โ–‘

Seedling to flower bloom

IF REPT

Put growth progress 0-10 in A1. Sprouts become plants, then blossoms.

=IF(A1<=3,REPT("๐ŸŒฑ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐ŸŒฑ",3)&REPT("๐ŸŒฟ",A1-3)&REPT("โ–‘",10-A1),REPT("๐ŸŒฑ",3)&REPT("๐ŸŒฟ",3)&REPT("๐ŸŒธ",A1-6)&REPT("โ–‘",10-A1)))

๐ŸŒฑ๐ŸŒฑ๐ŸŒฑ๐ŸŒฟ๐ŸŒฟ๐ŸŒฟ๐ŸŒธ๐ŸŒธโ–‘โ–‘

Cow herd to milk

IF REPT

Put dairy progress 0-10 in A1. Cows fill the bar, then milk takes over.

=IF(A1<=5,REPT("๐Ÿ„",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ„",5)&REPT("๐Ÿฅ›",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ„๐Ÿ„๐Ÿ„๐Ÿ„๐Ÿ„๐Ÿฅ›๐Ÿฅ›๐Ÿฅ›โ–‘โ–‘

Egg to chicken

IF REPT

Put hatch progress 0-10 in A1. Eggs crack, chicks emerge, hens rule the roost.

=IF(A1<=3,REPT("๐Ÿฅš",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿฅš",3)&REPT("๐Ÿฃ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿฅš",3)&REPT("๐Ÿฃ",3)&REPT("๐Ÿ”",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿฅš๐Ÿฅš๐Ÿฅš๐Ÿฃ๐Ÿฃ๐Ÿฃ๐Ÿ”๐Ÿ”โ–‘โ–‘

Grapes to wine

IF REPT

Put ferment progress 0-10 in A1. Clusters crush down into glasses of wine.

=IF(A1<=5,REPT("๐Ÿ‡",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ‡",5)&REPT("๐Ÿท",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿท๐Ÿท๐Ÿทโ–‘โ–‘

Dough to bread

IF REPT

Put bake progress 0-10 in A1. Dough rises in the oven, then comes out as loaves.

=IF(A1<=3,REPT("๐Ÿซ“",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿซ“",3)&REPT("๐Ÿ”ฅ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿซ“",3)&REPT("๐Ÿ”ฅ",3)&REPT("๐Ÿž",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿซ“๐Ÿซ“๐Ÿซ“๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿž๐Ÿžโ–‘โ–‘

Caterpillar to butterfly

IF REPT

Put metamorphosis progress 0-10 in A1. Larva cocoons, then wings unfurl.

=IF(A1<=3,REPT("๐Ÿ›",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿ›",3)&REPT("๐Ÿ›Œ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿ›",3)&REPT("๐Ÿ›Œ",3)&REPT("๐Ÿฆ‹",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿ›๐Ÿ›๐Ÿ›๐Ÿ›Œ๐Ÿ›Œ๐Ÿ›Œ๐Ÿฆ‹๐Ÿฆ‹โ–‘โ–‘

Wheat to toast

IF REPT

Put harvest progress 0-10 in A1. Grain becomes dough, then golden toast.

=IF(A1<=3,REPT("๐ŸŒพ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐ŸŒพ",3)&REPT("๐Ÿซ“",A1-3)&REPT("โ–‘",10-A1),REPT("๐ŸŒพ",3)&REPT("๐Ÿซ“",3)&REPT("๐Ÿž",A1-6)&REPT("โ–‘",10-A1)))

๐ŸŒพ๐ŸŒพ๐ŸŒพ๐Ÿซ“๐Ÿซ“๐Ÿซ“๐Ÿž๐Ÿžโ–‘โ–‘

Bean to coffee cup

IF REPT

Put brew progress 0-10 in A1. Beans grind down into steaming cups.

=IF(A1<=5,REPT("๐Ÿซ˜",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿซ˜",5)&REPT("โ˜•",A1-5)&REPT("โ–‘",10-A1))

๐Ÿซ˜๐Ÿซ˜๐Ÿซ˜๐Ÿซ˜๐Ÿซ˜โ˜•โ˜•โ˜•โ–‘โ–‘

Cocoa to chocolate

IF REPT

Put melt progress 0-10 in A1. Pods and beans become chocolate bars.

=IF(A1<=5,REPT("๐ŸŒฐ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŒฐ",5)&REPT("๐Ÿซ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŒฐ๐ŸŒฐ๐ŸŒฐ๐ŸŒฐ๐ŸŒฐ๐Ÿซ๐Ÿซ๐Ÿซโ–‘โ–‘

Ice cube to puddle

IF REPT

Put melt progress 0-10 in A1. Ice thaws into water.

=IF(A1<=5,REPT("๐ŸงŠ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸงŠ",5)&REPT("๐Ÿ’ง",A1-5)&REPT("โ–‘",10-A1))

๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐Ÿ’ง๐Ÿ’ง๐Ÿ’งโ–‘โ–‘

Snow to snowman

IF REPT

Put build progress 0-10 in A1. Flakes pile up into a finished snowman.

=IF(A1<=6,REPT("โ„๏ธ",A1)&REPT("โ–‘",10-A1),REPT("โ„๏ธ",6)&REPT("โ›„",A1-6)&REPT("โ–‘",10-A1))

โ„๏ธโ„๏ธโ„๏ธโ„๏ธโ„๏ธโ„๏ธโ›„โ›„โ›„โ–‘

Cloud to rainfall

IF REPT

Put storm progress 0-10 in A1. Clouds darken, then rain pours down.

=IF(A1<=5,REPT("โ˜๏ธ",A1)&REPT("โ–‘",10-A1),REPT("โ˜๏ธ",5)&REPT("๐ŸŒง๏ธ",A1-5)&REPT("โ–‘",10-A1))

โ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธ๐ŸŒง๏ธ๐ŸŒง๏ธ๐ŸŒง๏ธโ–‘โ–‘

Fish to sushi

IF REPT

Put prep progress 0-10 in A1. Fresh catch becomes plated sushi.

=IF(A1<=5,REPT("๐ŸŸ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŸ",5)&REPT("๐Ÿฃ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŸ๐ŸŸ๐ŸŸ๐ŸŸ๐ŸŸ๐Ÿฃ๐Ÿฃ๐Ÿฃโ–‘โ–‘

Potato to fries

IF REPT

Put fry progress 0-10 in A1. Spuds slice up into crispy fries.

=IF(A1<=5,REPT("๐Ÿฅ”",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿฅ”",5)&REPT("๐ŸŸ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿฅ”๐Ÿฅ”๐Ÿฅ”๐Ÿฅ”๐Ÿฅ”๐ŸŸ๐ŸŸ๐ŸŸโ–‘โ–‘

Tomato to pizza

IF REPT

Put cook progress 0-10 in A1. Tomatoes sauce up into a hot pizza.

=IF(A1<=5,REPT("๐Ÿ…",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ…",5)&REPT("๐Ÿ•",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ…๐Ÿ…๐Ÿ…๐Ÿ…๐Ÿ…๐Ÿ•๐Ÿ•๐Ÿ•โ–‘โ–‘

Bees to honey

IF REPT

Put pollination progress 0-10 in A1. Bees buzz, then honey fills the jar.

=IF(A1<=5,REPT("๐Ÿ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ",5)&REPT("๐Ÿฏ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ๐Ÿ๐Ÿ๐Ÿ๐Ÿ๐Ÿฏ๐Ÿฏ๐Ÿฏโ–‘โ–‘

Milk to cheese

IF REPT

Put aging progress 0-10 in A1. Milk curdles into cheese wheels.

=IF(A1<=5,REPT("๐Ÿฅ›",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿฅ›",5)&REPT("๐Ÿง€",A1-5)&REPT("โ–‘",10-A1))

๐Ÿฅ›๐Ÿฅ›๐Ÿฅ›๐Ÿฅ›๐Ÿฅ›๐Ÿง€๐Ÿง€๐Ÿง€โ–‘โ–‘

Corn to popcorn

IF REPT

Put pop progress 0-10 in A1. Kernels heat up and burst into popcorn.

=IF(A1<=4,REPT("๐ŸŒฝ",A1)&REPT("โ–‘",10-A1),IF(A1<=7,REPT("๐ŸŒฝ",4)&REPT("๐Ÿ”ฅ",A1-4)&REPT("โ–‘",10-A1),REPT("๐ŸŒฝ",4)&REPT("๐Ÿ”ฅ",3)&REPT("๐Ÿฟ",A1-7)&REPT("โ–‘",10-A1)))

๐ŸŒฝ๐ŸŒฝ๐ŸŒฝ๐ŸŒฝ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿฟ๐Ÿฟโ–‘

Apple to pie

IF REPT

Put bake progress 0-10 in A1. Apples slice up into a fresh pie.

=IF(A1<=5,REPT("๐ŸŽ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŽ",5)&REPT("๐Ÿฅง",A1-5)&REPT("โ–‘",10-A1))

๐ŸŽ๐ŸŽ๐ŸŽ๐ŸŽ๐ŸŽ๐Ÿฅง๐Ÿฅง๐Ÿฅงโ–‘โ–‘

Pig to bacon

IF REPT

Put cook progress 0-10 in A1. Pork sizzles into crispy bacon strips.

=IF(A1<=5,REPT("๐Ÿท",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿท",5)&REPT("๐Ÿฅ“",A1-5)&REPT("โ–‘",10-A1))

๐Ÿท๐Ÿท๐Ÿท๐Ÿท๐Ÿท๐Ÿฅ“๐Ÿฅ“๐Ÿฅ“โ–‘โ–‘

Coal to diamond

IF REPT

Put pressure progress 0-10 in A1. Black coal compresses into diamonds.

=IF(A1<=5,REPT("โฌ›",A1)&REPT("โ–‘",10-A1),REPT("โฌ›",5)&REPT("๐Ÿ’Ž",A1-5)&REPT("โ–‘",10-A1))

โฌ›โฌ›โฌ›โฌ›โฌ›๐Ÿ’Ž๐Ÿ’Ž๐Ÿ’Žโ–‘โ–‘

Lemon to lemonade

IF REPT

Put squeeze progress 0-10 in A1. Lemons juice up into cold lemonade.

=IF(A1<=5,REPT("๐Ÿ‹",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ‹",5)&REPT("๐Ÿฅค",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ‹๐Ÿ‹๐Ÿ‹๐Ÿ‹๐Ÿ‹๐Ÿฅค๐Ÿฅค๐Ÿฅคโ–‘โ–‘

Seed to pumpkin

IF REPT

Put grow progress 0-10 in A1. Sprouts vine out into a giant pumpkin.

=IF(A1<=5,REPT("๐ŸŒฑ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŒฑ",5)&REPT("๐ŸŽƒ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŒฑ๐ŸŒฑ๐ŸŒฑ๐ŸŒฑ๐ŸŒฑ๐ŸŽƒ๐ŸŽƒ๐ŸŽƒโ–‘โ–‘

Trash to recycling

IF REPT

Put sort progress 0-10 in A1. Waste bins empty into green recycling.

=IF(A1<=5,REPT("๐Ÿ—‘๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ—‘๏ธ",5)&REPT("โ™ป๏ธ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ—‘๏ธ๐Ÿ—‘๏ธ๐Ÿ—‘๏ธ๐Ÿ—‘๏ธ๐Ÿ—‘๏ธโ™ป๏ธโ™ป๏ธโ™ป๏ธโ–‘โ–‘

Letter to mailbox

IF REPT

Put delivery progress 0-10 in A1. Envelopes travel to the mailbox.

=IF(A1<=5,REPT("โœ‰๏ธ",A1)&REPT("โ–‘",10-A1),REPT("โœ‰๏ธ",5)&REPT("๐Ÿ“ฌ",A1-5)&REPT("โ–‘",10-A1))

โœ‰๏ธโœ‰๏ธโœ‰๏ธโœ‰๏ธโœ‰๏ธ๐Ÿ“ฌ๐Ÿ“ฌ๐Ÿ“ฌโ–‘โ–‘

Ore to gold

IF REPT

Put mining progress 0-10 in A1. Pickaxes strike rock, then gold appears.

=IF(A1<=3,REPT("โ›๏ธ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("โ›๏ธ",3)&REPT("๐Ÿชจ",A1-3)&REPT("โ–‘",10-A1),REPT("โ›๏ธ",3)&REPT("๐Ÿชจ",3)&REPT("๐Ÿ’ฐ",A1-6)&REPT("โ–‘",10-A1)))

โ›๏ธโ›๏ธโ›๏ธ๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿ’ฐ๐Ÿ’ฐโ–‘โ–‘

Brick to house

IF REPT

Put build progress 0-10 in A1. Bricks stack up into a finished home.

=IF(A1<=6,REPT("๐Ÿงฑ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿงฑ",6)&REPT("๐Ÿ ",A1-6)&REPT("โ–‘",10-A1))

๐Ÿงฑ๐Ÿงฑ๐Ÿงฑ๐Ÿงฑ๐Ÿงฑ๐Ÿงฑ๐Ÿ ๐Ÿ ๐Ÿ โ–‘

Yarn to sweater

IF REPT

Put knit progress 0-10 in A1. Balls of yarn become a cozy sweater.

=IF(A1<=5,REPT("๐Ÿงถ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿงถ",5)&REPT("๐Ÿงฅ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿงถ๐Ÿงถ๐Ÿงถ๐Ÿงถ๐Ÿงถ๐Ÿงฅ๐Ÿงฅ๐Ÿงฅโ–‘โ–‘

Water to tea

IF REPT

Put steep progress 0-10 in A1. Water heats, brews, then pours into cups.

=IF(A1<=3,REPT("๐Ÿ’ง",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿ’ง",3)&REPT("๐Ÿซ–",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿ’ง",3)&REPT("๐Ÿซ–",3)&REPT("๐Ÿต",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿ’ง๐Ÿ’ง๐Ÿ’ง๐Ÿซ–๐Ÿซ–๐Ÿซ–๐Ÿต๐Ÿตโ–‘โ–‘

Rock to gem

IF REPT

Put polish progress 0-10 in A1. Rough stone cuts into a sparkling gem.

=IF(A1<=5,REPT("๐Ÿชจ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿชจ",5)&REPT("๐Ÿ’Ž",A1-5)&REPT("โ–‘",10-A1))

๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿ’Ž๐Ÿ’Ž๐Ÿ’Žโ–‘โ–‘

Egg to omelette

IF REPT

Put cook progress 0-10 in A1. Eggs crack, hit the pan, then plate up.

=IF(A1<=3,REPT("๐Ÿฅš",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿฅš",3)&REPT("๐Ÿณ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿฅš",3)&REPT("๐Ÿณ",3)&REPT("๐Ÿฝ๏ธ",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿฅš๐Ÿฅš๐Ÿฅš๐Ÿณ๐Ÿณ๐Ÿณ๐Ÿฝ๏ธ๐Ÿฝ๏ธโ–‘โ–‘

Sand to sandcastle

IF REPT

Put sculpt progress 0-10 in A1. Beach sand piles into a castle.

=IF(A1<=5,REPT("๐Ÿ–๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ–๏ธ",5)&REPT("๐Ÿฐ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ–๏ธ๐Ÿ–๏ธ๐Ÿ–๏ธ๐Ÿ–๏ธ๐Ÿ–๏ธ๐Ÿฐ๐Ÿฐ๐Ÿฐโ–‘โ–‘

Flour to cake

IF REPT

Put bake progress 0-10 in A1. Flour mixes, bakes, then becomes cake.

=IF(A1<=3,REPT("๐ŸŒพ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐ŸŒพ",3)&REPT("๐Ÿ”ฅ",A1-3)&REPT("โ–‘",10-A1),REPT("๐ŸŒพ",3)&REPT("๐Ÿ”ฅ",3)&REPT("๐ŸŽ‚",A1-6)&REPT("โ–‘",10-A1)))

๐ŸŒพ๐ŸŒพ๐ŸŒพ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐ŸŽ‚๐ŸŽ‚โ–‘โ–‘

Cash to bank

IF REPT

Put deposit progress 0-10 in A1. Bills stack up, then land in the bank.

=IF(A1<=3,REPT("๐Ÿ’ต",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿ’ต",3)&REPT("๐Ÿ’ฐ",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿ’ต",3)&REPT("๐Ÿ’ฐ",3)&REPT("๐Ÿฆ",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿ’ต๐Ÿ’ต๐Ÿ’ต๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿฆ๐Ÿฆโ–‘โ–‘

Coins to piggy bank

IF REPT

Put savings progress 0-10 in A1. Coins clink in until the piggy bank is full.

=IF(A1<=6,REPT("๐Ÿช™",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿช™",6)&REPT("๐Ÿท",A1-6)&REPT("โ–‘",10-A1))

๐Ÿช™๐Ÿช™๐Ÿช™๐Ÿช™๐Ÿช™๐Ÿช™๐Ÿท๐Ÿท๐Ÿทโ–‘

Paycheck to savings

IF REPT

Put save progress 0-10 in A1. Pay arrives, cash stacks, then hits the vault.

=IF(A1<=3,REPT("๐Ÿ’ผ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐Ÿ’ผ",3)&REPT("๐Ÿ’ต",A1-3)&REPT("โ–‘",10-A1),REPT("๐Ÿ’ผ",3)&REPT("๐Ÿ’ต",3)&REPT("๐Ÿฆ",A1-6)&REPT("โ–‘",10-A1)))

๐Ÿ’ผ๐Ÿ’ผ๐Ÿ’ผ๐Ÿ’ต๐Ÿ’ต๐Ÿ’ต๐Ÿฆ๐Ÿฆโ–‘โ–‘

Wallet to bank

IF REPT

Put transfer progress 0-10 in A1. Cash leaves the wallet and reaches the bank.

=IF(A1<=5,REPT("๐Ÿ‘›",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ‘›",5)&REPT("๐Ÿฆ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ‘›๐Ÿ‘›๐Ÿ‘›๐Ÿ‘›๐Ÿ‘›๐Ÿฆ๐Ÿฆ๐Ÿฆโ–‘โ–‘

Cart to checkout

IF REPT

Put shop progress 0-10 in A1. Groceries fill the cart, then you pay at checkout.

=IF(A1<=6,REPT("๐Ÿ›’",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ›’",6)&REPT("๐Ÿ’ณ",A1-6)&REPT("โ–‘",10-A1))

๐Ÿ›’๐Ÿ›’๐Ÿ›’๐Ÿ›’๐Ÿ›’๐Ÿ›’๐Ÿ’ณ๐Ÿ’ณ๐Ÿ’ณโ–‘

Invoice to paid

IF REPT

Put billing progress 0-10 in A1. Invoices clear, then payment lands.

=IF(A1<=4,REPT("๐Ÿ“„",A1)&REPT("โ–‘",10-A1),IF(A1<=7,REPT("๐Ÿ“„",4)&REPT("โœ…",A1-4)&REPT("โ–‘",10-A1),REPT("๐Ÿ“„",4)&REPT("โœ…",3)&REPT("๐Ÿ’ฐ",A1-7)&REPT("โ–‘",10-A1)))

๐Ÿ“„๐Ÿ“„๐Ÿ“„๐Ÿ“„โœ…โœ…โœ…๐Ÿ’ฐ๐Ÿ’ฐโ–‘

Rain to rainbow

IF REPT

Put clearing progress 0-10 in A1. Storm clouds break into a rainbow.

=IF(A1<=5,REPT("๐ŸŒง๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŒง๏ธ",5)&REPT("๐ŸŒˆ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŒง๏ธ๐ŸŒง๏ธ๐ŸŒง๏ธ๐ŸŒง๏ธ๐ŸŒง๏ธ๐ŸŒˆ๐ŸŒˆ๐ŸŒˆโ–‘โ–‘

Night to day

IF REPT

Put dawn progress 0-10 in A1. Moon fades as the sun rises.

=IF(A1<=5,REPT("๐ŸŒ™",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŒ™",5)&REPT("โ˜€๏ธ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŒ™๐ŸŒ™๐ŸŒ™๐ŸŒ™๐ŸŒ™โ˜€๏ธโ˜€๏ธโ˜€๏ธโ–‘โ–‘

Candle to light bulb

IF REPT

Put upgrade progress 0-10 in A1. Candle flame gives way to electric light.

=IF(A1<=5,REPT("๐Ÿ•ฏ๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ•ฏ๏ธ",5)&REPT("๐Ÿ’ก",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ๐Ÿ’ก๐Ÿ’ก๐Ÿ’กโ–‘โ–‘

Wood to paper

IF REPT

Put mill progress 0-10 in A1. Logs pulp down into sheets of paper.

=IF(A1<=5,REPT("๐Ÿชต",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿชต",5)&REPT("๐Ÿ“„",A1-5)&REPT("โ–‘",10-A1))

๐Ÿชต๐Ÿชต๐Ÿชต๐Ÿชต๐Ÿชต๐Ÿ“„๐Ÿ“„๐Ÿ“„โ–‘โ–‘

Sheep to yarn

IF REPT

Put shear progress 0-10 in A1. Wool clips off the flock into yarn balls.

=IF(A1<=5,REPT("๐Ÿ‘",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ‘",5)&REPT("๐Ÿงถ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿงถ๐Ÿงถ๐Ÿงถโ–‘โ–‘

Oil barrel to gas pump

IF REPT

Put refine progress 0-10 in A1. Crude oil becomes fuel at the pump.

=IF(A1<=5,REPT("๐Ÿ›ข๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ›ข๏ธ",5)&REPT("โ›ฝ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ›ข๏ธ๐Ÿ›ข๏ธ๐Ÿ›ข๏ธ๐Ÿ›ข๏ธ๐Ÿ›ข๏ธโ›ฝโ›ฝโ›ฝโ–‘โ–‘

Seed to apple tree

IF REPT

Put orchard progress 0-10 in A1. Sprouts grow into trees heavy with apples.

=IF(A1<=3,REPT("๐ŸŒฑ",A1)&REPT("โ–‘",10-A1),IF(A1<=6,REPT("๐ŸŒฑ",3)&REPT("๐ŸŒณ",A1-3)&REPT("โ–‘",10-A1),REPT("๐ŸŒฑ",3)&REPT("๐ŸŒณ",3)&REPT("๐ŸŽ",A1-6)&REPT("โ–‘",10-A1)))

๐ŸŒฑ๐ŸŒฑ๐ŸŒฑ๐ŸŒณ๐ŸŒณ๐ŸŒณ๐ŸŽ๐ŸŽโ–‘โ–‘

Idea to rocket launch

IF REPT

Put startup progress 0-10 in A1. Lightbulb moments lift off into launch.

=IF(A1<=5,REPT("๐Ÿ’ก",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ’ก",5)&REPT("๐Ÿš€",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ’ก๐Ÿ’ก๐Ÿ’ก๐Ÿ’ก๐Ÿ’ก๐Ÿš€๐Ÿš€๐Ÿš€โ–‘โ–‘

Pen to published book

IF REPT

Put writing progress 0-10 in A1. Drafts scribble out into a finished book.

=IF(A1<=5,REPT("๐Ÿ–Š๏ธ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ–Š๏ธ",5)&REPT("๐Ÿ“–",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ–Š๏ธ๐Ÿ–Š๏ธ๐Ÿ–Š๏ธ๐Ÿ–Š๏ธ๐Ÿ–Š๏ธ๐Ÿ“–๐Ÿ“–๐Ÿ“–โ–‘โ–‘

Grapes to jam jar

IF REPT

Put preserve progress 0-10 in A1. Grape clusters cook down into jam.

=IF(A1<=5,REPT("๐Ÿ‡",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ‡",5)&REPT("๐Ÿซ™",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿ‡๐Ÿซ™๐Ÿซ™๐Ÿซ™โ–‘โ–‘

Clay to pottery

IF REPT

Put kiln progress 0-10 in A1. Wet clay fires into finished pottery.

=IF(A1<=4,REPT("๐ŸŸค",A1)&REPT("โ–‘",10-A1),IF(A1<=7,REPT("๐ŸŸค",4)&REPT("๐Ÿ”ฅ",A1-4)&REPT("โ–‘",10-A1),REPT("๐ŸŸค",4)&REPT("๐Ÿ”ฅ",3)&REPT("๐Ÿบ",A1-7)&REPT("โ–‘",10-A1)))

๐ŸŸค๐ŸŸค๐ŸŸค๐ŸŸค๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿบ๐Ÿบโ–‘

Paint to masterpiece

IF REPT

Put art progress 0-10 in A1. Palette strokes become a framed painting.

=IF(A1<=5,REPT("๐ŸŽจ",A1)&REPT("โ–‘",10-A1),REPT("๐ŸŽจ",5)&REPT("๐Ÿ–ผ๏ธ",A1-5)&REPT("โ–‘",10-A1))

๐ŸŽจ๐ŸŽจ๐ŸŽจ๐ŸŽจ๐ŸŽจ๐Ÿ–ผ๏ธ๐Ÿ–ผ๏ธ๐Ÿ–ผ๏ธโ–‘โ–‘

Homework to diploma

IF REPT

Put study progress 0-10 in A1. Books stack up into a graduation diploma.

=IF(A1<=6,REPT("๐Ÿ“š",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ“š",6)&REPT("๐ŸŽ“",A1-6)&REPT("โ–‘",10-A1))

๐Ÿ“š๐Ÿ“š๐Ÿ“š๐Ÿ“š๐Ÿ“š๐Ÿ“š๐ŸŽ“๐ŸŽ“๐ŸŽ“โ–‘

Question to answer

IF REPT

Put solve progress 0-10 in A1. Puzzles click from questions into answers.

=IF(A1<=5,REPT("โ“",A1)&REPT("โ–‘",10-A1),REPT("โ“",5)&REPT("โœ…",A1-5)&REPT("โ–‘",10-A1))

โ“โ“โ“โ“โ“โœ…โœ…โœ…โ–‘โ–‘

Maple sap to syrup

IF REPT

Put boil progress 0-10 in A1. Sap drips from leaves into golden syrup.

=IF(A1<=5,REPT("๐Ÿ",A1)&REPT("โ–‘",10-A1),REPT("๐Ÿ",5)&REPT("๐Ÿฏ",A1-5)&REPT("โ–‘",10-A1))

๐Ÿ๐Ÿ๐Ÿ๐Ÿ๐Ÿ๐Ÿฏ๐Ÿฏ๐Ÿฏโ–‘โ–‘

Sunrise over horizon

REPT MAX

Put time of day 0-10 in A1. Sunrise moves across the sky.

=REPT("ยท",A1)&"๐ŸŒ…"&REPT("ยท",MAX(0,10-A1))

ยทยทยทยท๐ŸŒ…ยทยทยทยทยทยท

Time of day sky

REPT MAX IF

Put hour progress 0-10 in A1. Sunrise, midday sun, or sunset as the day moves.

=REPT("ยท",A1)&IF(A1<=3,"๐ŸŒ…",IF(A1<=7,"โ˜€๏ธ","๐ŸŒ‡"))&REPT("ยท",MAX(0,10-A1))

ยทยทยทยทโ˜€๏ธยทยทยทยทยท

Penguin march line

REPT MAX

Put penguin count in A1. Marching line with dots.

=REPT("๐Ÿง",A1)&REPT("ยท",MAX(0,6-A1))

๐Ÿง๐Ÿง๐Ÿงยทยทยท

Car trip to mountain (arrow trail)

REPT MAX

Put trip progress 0-10 in A1. Arrow waypoints trail the car toward the mountain.

="๐Ÿ”๏ธ"&REPT("โ†",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿ”๏ธโ†โ†โ†โ†โ†โ†๐Ÿš—ใƒปใƒป

Car trip to McDonald's (arrow trail)

REPT MAX

Put trip progress 0-10 in A1. Arrow waypoints trail the car toward the fries.

="๐ŸŸ"&REPT("โ†",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐ŸŸโ†โ†โ†โ†โ†โ†๐Ÿš—ใƒปใƒป

Burger run by car (arrow trail)

REPT MAX

Put trip progress 0-10 in A1. Arrow waypoints trail the car toward a hamburger.

="๐Ÿ”"&REPT("โ†",MAX(0,10-A1))&"๐Ÿš—"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿ”โ†โ†โ†โ†โ†โ†๐Ÿš—ใƒปใƒป

Soda run to drink break (arrow trail)

REPT MAX

Put break progress 0-10 in A1. Arrow waypoints trail the soda toward a drink break.

="โ˜•"&REPT("โ†",MAX(0,10-A1))&"๐Ÿฅค"&REPT("ใƒป",MAX(0,A1-2))

โ˜•โ†โ†โ†โ†โ†โ†๐Ÿฅคใƒปใƒป

Snack run to snack break (arrow trail)

REPT MAX

Put break progress 0-10 in A1. Arrow waypoints trail the snack toward popcorn.

="๐Ÿฟ"&REPT("โ†",MAX(0,10-A1))&"๐Ÿช"&REPT("ใƒป",MAX(0,A1-2))

๐Ÿฟโ†โ†โ†โ†โ†โ†๐Ÿชใƒปใƒป

Snail race to finish (arrow trail)

REPT MAX

Put lap position 0-10 in A1. Arrow waypoints show where the snail has already crawled.

=REPT("โ†",A1)&"๐ŸŒ"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ"

โ†โ†โ†๐ŸŒใƒปใƒปใƒปใƒปใƒป๐Ÿ

Rocket launch pad (arrow trail)

REPT MAX CHAR

Higher A1 adds more flame blocks under the rocket. Arrow waypoints mark the pad approach.

=REPT("โ†",MAX(0,8-A1))&"๐Ÿš€"&REPT(CHAR(9650),A1)

โ†โ†โ†โ†โ†๐Ÿš€โ–ฒโ–ฒโ–ฒ

Pin map journey (arrow trail)

REPT MAX

Put progress 0-10 in A1. Arrow waypoints show the route behind the pin.

=REPT("โ†",A1)&"๐Ÿ“"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ "

โ†โ†โ†๐Ÿ“ใƒปใƒปใƒปใƒป๐Ÿ 

Ship sailing home (ripple trail)

REPT MAX

Put progress 0-8 in A1. Ripple waves trail behind the boat, ocean ahead.

=REPT("ใ€ฐ๏ธ",A1)&"โ›ต"&REPT("๐ŸŒŠ",MAX(0,8-A1))

ใ€ฐ๏ธใ€ฐ๏ธใ€ฐ๏ธโ›ต๐ŸŒŠ๐ŸŒŠ๐ŸŒŠ๐ŸŒŠ

Sunrise over horizon (arrow trail)

REPT MAX

Put time of day 0-10 in A1. Arrow waypoints mark the sunrise path across the sky.

=REPT("โ†",A1)&"๐ŸŒ…"&REPT("ใƒป",MAX(0,10-A1))

โ†โ†โ†โ†๐ŸŒ…ใƒปใƒปใƒปใƒปใƒป

Time of day sky (arrow trail)

REPT MAX IF

Put hour progress 0-10 in A1. Arrow waypoints trail sunrise, midday sun, or sunset.

=REPT("โ†",A1)&IF(A1<=3,"๐ŸŒ…",IF(A1<=7,"โ˜€๏ธ","๐ŸŒ‡"))&REPT("ใƒป",MAX(0,10-A1))

โ†โ†โ†โ†โ˜€๏ธใƒปใƒปใƒปใƒปใƒป

Penguin march line (arrow trail)

REPT MAX

Put penguin count in A1. Arrow waypoints mark the march behind the flock.

=REPT("๐Ÿง",A1)&REPT("โ†",MAX(0,6-A1))

๐Ÿง๐Ÿง๐Ÿงโ†โ†โ†

Butterfly garden count

REPT

Put butterfly count 0-5 in A1.

=REPT("๐Ÿฆ‹",A1)&REPT("๐ŸŒธ",5-A1)

๐Ÿฆ‹๐Ÿฆ‹๐Ÿฆ‹๐ŸŒธ๐ŸŒธ

X-wing Death Star trench run

REPT MAX

Put lap position 0-10 in A1. Fighter closes on the Death Star.

=REPT("ใƒป",A1)&"๐Ÿ›ธ"&REPT("ใƒป",MAX(0,10-A1))&"๐ŸŒ‘"

ใƒปใƒปใƒป๐Ÿ›ธใƒปใƒปใƒปใƒปใƒป๐ŸŒ‘

Millennium Falcon Kessel Run

REPT MAX

Put parsecs 0-10 in A1. More stars means faster through hyperspace.

=REPT("โœจ",A1)&"๐Ÿš€"&REPT("โœจ",MAX(0,10-A1))

โœจโœจโœจ๐Ÿš€โœจโœจโœจโœจโœจโœจ

Hyperspace jump streak

REPT MAX

Put jump progress 0-10 in A1. Sparkles trail the rocket.

=REPT("โœจ",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿš€"

โœจโœจโœจโœจใƒปใƒปใƒปใƒป๐Ÿš€

Rescue Princess Leia

REPT MAX

Put rescue progress 0-10 in A1. Ship races toward the princess.

=REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ‘ธ"&REPT("ใƒป",A1)&"๐Ÿš€"

ใƒปใƒปใƒปใƒปใƒป๐Ÿ‘ธใƒปใƒปใƒป๐Ÿš€

Escape from Hoth

REPT MAX

Put launch progress 0-10 in A1. Ship lifts off the ice planet.

=REPT("ใƒป",A1)&"๐Ÿš€"&REPT("ใƒป",MAX(0,10-A1))&"โ„๏ธ"

ใƒปใƒป๐Ÿš€ใƒปใƒปใƒปใƒปใƒปใƒปโ„๏ธ

Tatooine desert crossing

REPT MAX

Put journey progress 0-10 in A1. Cross the dunes to twin suns.

=๐Ÿœ๏ธ&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿค–"&REPT("ใƒป",A1)&"โ˜€๏ธ"

๐Ÿœ๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿค–ใƒปใƒปใƒปโ˜€๏ธ

Podrace lap counter

REPT MAX

Put laps completed in A1.

=REPT("๐ŸŽ๏ธ",A1)&REPT("ใƒป",MAX(0,6-A1))&"๐Ÿ"

๐ŸŽ๏ธ๐ŸŽ๏ธ๐ŸŽ๏ธใƒปใƒปใƒป๐Ÿ

Asteroid field dodge run

REPT MAX

Put asteroids dodged 0-8 in A1. Ship escapes at the end.

=REPT("โ˜„๏ธ",A1)&REPT("ใƒป",MAX(0,8-A1))&"๐Ÿš€"

โ˜„๏ธโ˜„๏ธโ˜„๏ธใƒปใƒปใƒป๐Ÿš€

Bounty hunter pursuit

REPT MAX

Put pursuit progress 0-10 in A1. Target closes on the payout.

=REPT("ใƒป",MAX(0,10-A1))&"๐ŸŽฏ"&REPT("ใƒป",A1)&"๐Ÿ’ฐ"

ใƒปใƒปใƒปใƒปใƒป๐ŸŽฏใƒปใƒปใƒป๐Ÿ’ฐ

Sarlacc pit fall

REPT MAX

Put fall progress 0-10 in A1. One step closer to the Sarlacc.

=REPT("ใƒป",A1)&"๐Ÿ‘ค"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ•ณ๏ธ"

ใƒปใƒป๐Ÿ‘คใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿ•ณ๏ธ

Death Star exhaust port shot

REPT MAX

Put aim progress 0-10 in A1. Proton torpedo homes in on the target.

=REPT("ใƒป",MAX(0,10-A1))&"๐ŸŽฏ"&REPT("ใƒป",A1)&"๐Ÿ’ฅ"

ใƒปใƒปใƒปใƒปใƒป๐ŸŽฏใƒปใƒปใƒป๐Ÿ’ฅ

AT-AT march on Hoth

REPT MAX

Put march progress 0-10 in A1. Walker advances across the ice.

=REPT("ใƒป",A1)&"๐Ÿค–"&REPT("ใƒป",MAX(0,10-A1))&"โ„๏ธ"

ใƒปใƒปใƒป๐Ÿค–ใƒปใƒปใƒปใƒปใƒปโ„๏ธ

Endor shield generator raid

REPT MAX

Put raid progress 0-10 in A1. Squad pushes through the forest.

=REPT("๐ŸŒฒ",A1)&"๐Ÿ›ก๏ธ"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’ฅ"

๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐Ÿ›ก๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿ’ฅ

Mustafar duel intensity

REPT MAX

Put duel intensity in A1. Flames flank crossed sabers.

=REPT("๐Ÿ”ฅ",A1)&"โš”๏ธ"&REPT("๐Ÿ”ฅ",MAX(0,5-A1))

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโš”๏ธ๐Ÿ”ฅ๐Ÿ”ฅ

Emperor force lightning

REPT

Put lightning level 0-5 in A1.

=REPT("โšก",A1)&REPT("โ—‹",5-A1)&" ๐Ÿ‘‘"

โšกโšกโšกโ—‹โ—‹ ๐Ÿ‘‘

Force power meter

REPT

Put force level 0-5 in A1.

=REPT("โœจ",A1)&REPT("โ—‹",5-A1)

โœจโœจโœจโ—‹โ—‹

Force lightning intensity

REPT

Put lightning bolts 0-5 in A1.

=REPT("โšก",A1)&REPT("โ—‹",5-A1)

โšกโšกโšกโ—‹โ—‹

Lightsaber training progress

REPT

Put training level 0-5 in A1.

=REPT("โš”๏ธ",A1)&REPT("โ—‹",5-A1)

โš”๏ธโš”๏ธโš”๏ธโ—‹โ—‹

Kyber crystal charge

REPT

Put crystal charge 0-5 in A1.

=REPT("๐Ÿ’Ž",A1)&REPT("โ—‹",5-A1)

๐Ÿ’Ž๐Ÿ’Ž๐Ÿ’Žโ—‹โ—‹

Rebel alliance star rating

REPT

Put rebel rating 0-5 in A1.

=REPT("โญ",A1)&REPT("โ˜†",5-A1)&" Rebel"

โญโญโญโ˜†โ˜† Rebel

Death Star construction progress

REPT CHAR

Put build progress 0-10 in A1.

=REPT(CHAR(9608),A1)&REPT("โ–‘",10-A1)&" ๐ŸŒ‘"

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–‘โ–‘โ–‘โ–‘ ๐ŸŒ‘

Shield generator health

REPT

Put hull integrity 0-10 in A1.

=REPT("โ–ˆ",A1)&REPT("โ–‘",10-A1)&" ๐Ÿ›ก๏ธ"

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–‘โ–‘โ–‘โ–‘ ๐Ÿ›ก๏ธ

Carbonite freezing progress

REPT

Put freeze progress 0-10 in A1.

=REPT("โ–ˆ",A1)&REPT("โ–‘",10-A1)&" ๐ŸงŠ"

โ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–ˆโ–‘โ–‘โ–‘โ–‘ ๐ŸงŠ

Droid army counter

REPT

Put droid count 0-5 in A1.

=REPT("๐Ÿค–",A1)&REPT("โ—‹",5-A1)

๐Ÿค–๐Ÿค–๐Ÿค–โ—‹โ—‹

Stormtrooper squad size

REPT

Put squad size 0-5 in A1.

=REPT("๐Ÿช–",A1)&REPT("โ—‹",5-A1)

๐Ÿช–๐Ÿช–๐Ÿช–โ—‹โ—‹

Clone trooper battalion

REPT

Put clone count in A1.

=REPT("๐Ÿช–",A1)&" clones"

๐Ÿช–๐Ÿช–๐Ÿช– clones

TIE fighter formation

REPT MAX

Put fighter count in A1.

=REPT("๐Ÿ›ธ",A1)&REPT("ใƒป",MAX(0,6-A1))

๐Ÿ›ธ๐Ÿ›ธ๐Ÿ›ธใƒปใƒปใƒป

Star Destroyer fleet count

REPT

Put destroyer count in A1.

=REPT("๐Ÿ›ธ",A1)&" Imperial fleet"

๐Ÿ›ธ๐Ÿ›ธ๐Ÿ›ธ Imperial fleet

Rebel starfighter squadron

REPT MIN

Put squadron size in A1.

=REPT("โญ",A1)&REPT("๐Ÿ›ธ",MIN(A1,3))

โญโญโญ๐Ÿ›ธ๐Ÿ›ธ๐Ÿ›ธ

R2-D2 beep meter

REPT

Put beep level 0-5 in A1.

=REPT("๐Ÿค–",1)&REPT("โ—",A1)&REPT("โ—‹",5-A1)

๐Ÿค–โ—โ—โ—โ—‹โ—‹

BB-8 roll distance

REPT MAX

Put roll distance 0-10 in A1.

=REPT("๐Ÿค–",1)&REPT("โ—",A1)&REPT("โ—‹",MAX(0,10-A1))

๐Ÿค–โ—โ—โ—โ—โ—‹โ—‹โ—‹โ—‹โ—‹โ—‹

C-3PO worry level

REPT

Put worry level in A1. More droids, more panic.

=REPT("๐Ÿค–",A1)&" Oh my!"

๐Ÿค–๐Ÿค–๐Ÿค– Oh my!

Porg infestation count

REPT

Put porg count in A1.

=REPT("๐Ÿฆ",A1)&" porgs"

๐Ÿฆ๐Ÿฆ๐Ÿฆ porgs

Baby Yoda soup rating

REPT

Put rating 1-5 in A1.

=REPT("๐Ÿฅฃ",1)&REPT("โญ",A1)&REPT("โ˜†",5-A1)

๐Ÿฅฃโญโญโญโ˜†โ˜†

Mandalorian beskar armor

REPT

Put armor plates 0-5 in A1.

=REPT("๐Ÿ›ก๏ธ",A1)&REPT("โ—‹",5-A1)

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธโ—‹โ—‹

Light side vs dark side meter

REPT

Put light-side score 0-5 in A1. Angels vs devils.

=REPT("๐Ÿ˜‡",A1)&REPT("๐Ÿ˜ˆ",5-A1)

๐Ÿ˜‡๐Ÿ˜‡๐Ÿ˜‡๐Ÿ˜ˆ๐Ÿ˜ˆ

Jedi or Sith alignment

IF

Put Jedi, Sith, or anything else in A1.

=IF(A1="Jedi","๐Ÿ˜‡ Light side",IF(A1="Sith","๐Ÿ˜ˆ Dark side","โš– Neutral"))

๐Ÿ˜‡ Light side

Lightsaber color picker

CHOOSE

Put number 1-5 in A1 for blade color.

=CHOOSE(A1,"๐Ÿ”ต Blue","๐ŸŸข Green","๐Ÿ”ด Red","๐ŸŸฃ Purple","โšช White")

๐Ÿ”ต Blue

Lightsaber duel winner

IF

Put Jedi power 0-10 in A1. Over 5 means the Jedi wins.

=IF(A1>5,"๐Ÿ˜‡ Jedi wins","๐Ÿ˜ˆ Sith wins")

๐Ÿ˜‡ Jedi wins

Hyperdrive motivator status

IF

Put 1 for ready, 0 for broken.

=IF(A1>0,"๐Ÿš€ Hyperspace ready","โš ๏ธ Motivator shot")

๐Ÿš€ Hyperspace ready

Tractor beam strength

REPT

Put beam strength 0-5 in A1.

=REPT("โ—Ž",A1)&REPT("โ—‹",5-A1)&" tractor beam"

โ—Žโ—Žโ—Žโ—‹โ—‹ tractor beam

Imperial loyalty meter

REPT

Put loyalty 0-5 in A1. Red vs black circles.

=REPT("๐Ÿ”ด",A1)&REPT("โšซ",5-A1)

๐Ÿ”ด๐Ÿ”ด๐Ÿ”ดโšซโšซ

Galactic Senate vote tally

REPT MAX

Put yes votes in A1 out of 10.

=REPT("๐Ÿ‘",A1)&REPT("๐Ÿ‘Ž",MAX(0,10-A1))

๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿ‘๐Ÿ‘Ž๐Ÿ‘Ž๐Ÿ‘Ž๐Ÿ‘Ž๐Ÿ‘Ž๐Ÿ‘Ž

Death Star plans recovered

REPT

Put plans found 0-3 in A1. Scrolls point to the Death Star.

=REPT("๐Ÿ“œ",A1)&REPT("โ—‹",3-A1)&" โ†’ ๐ŸŒ‘"

๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ โ†’ ๐ŸŒ‘

Ewok victory celebration

REPT MAX

Put celebration level in A1. Confetti and trees.

=REPT("๐ŸŽ‰",A1)&REPT("๐ŸŒฒ",MAX(0,3-A1))

๐ŸŽ‰๐ŸŽ‰๐ŸŽ‰๐ŸŒฒ

Vader force choke reach

REPT

Put reach distance in A1. Hand to target.

=REPT("โœ‹",1)&REPT("ใƒป",A1)&"๐Ÿ’€"

โœ‹ใƒปใƒปใƒป๐Ÿ’€

Wookiee roar volume

REPT MAX CHAR

Put roar volume in A1. Speaker plus block meter.

=REPT("๐Ÿ”Š",A1)&REPT(CHAR(9601),MAX(0,5-A1))

๐Ÿ”Š๐Ÿ”Š๐Ÿ”Šโ–โ–

Escape pod launch sequence

REPT MAX

Put launch progress 0-10 in A1.

=REPT("ใƒป",MAX(0,10-A1))&"๐Ÿš€"&REPT("ใƒป",A1)&"๐Ÿช"

ใƒปใƒปใƒปใƒปใƒป๐Ÿš€ใƒปใƒปใƒป๐Ÿช

Order 66 execution count

REPT

Put execution count in A1.

=REPT("โš”๏ธ",A1)&" executed"

โš”๏ธโš”๏ธโš”๏ธ executed

Yoda training patience

REPT

Put patience level 1-5 in A1.

=REPT("โœจ",A1)&" ...patience you must have"

โœจโœจโœจ ...patience you must have

Han Solo parsecs brag

REPT MIN

Put parsecs in A1.

=A1&" parsecs"&REPT("๐Ÿš€",MIN(A1,3))

12 parsecs๐Ÿš€๐Ÿš€๐Ÿš€

Imperial March footsteps

REPT

Put step count in A1. Dum-dum rhythm text.

=REPT("๐Ÿฅพ",A1)&" dum dum dum dum"

๐Ÿฅพ๐Ÿฅพ๐Ÿฅพ dum dum dum dum

Jabba palace audience

REPT

Put audience size in A1.

=REPT("๐Ÿ’ฐ",A1)&" palace"

๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ palace

Lightspeed skip damage risk

REPT IF MOD

Put risk level 0-10 in A1. Over 8 adds an explosion.

=REPT("โœจ",MOD(A1,5))&"๐Ÿš€"&REPT("๐Ÿ’ฅ",IF(A1>8,1,0))

โœจโœจ๐Ÿš€

Luke watches the twin suns

REPT MAX

Put steps toward the horizon 0-10 in A1. Luke on Tatooine at binary sunset.

=REPT("ใƒป",A1)&"๐Ÿง‘"&REPT("ใƒป",MAX(0,10-A1))&"โ˜€๏ธโ˜€๏ธ"

ใƒปใƒปใƒป๐Ÿง‘ใƒปใƒปใƒปใƒปใƒปใƒปโ˜€๏ธโ˜€๏ธ

Obi-Wan vs Vader duel

REPT

Put duel intensity 0-5 in A1. Crossed sabers on the Death Star.

=REPT("โš”๏ธ",A1)&REPT("โ—‹",5-A1)

โš”๏ธโš”๏ธโš”๏ธโ—‹โ—‹

Yoda lifting the X-Wing

REPT

Put force focus 0-5 in A1. Sparkles lift the fighter from the swamp.

=REPT("โœจ",A1)&"๐Ÿš€"

โœจโœจโœจ๐Ÿš€

Luke's trench approach

REPT MAX

Put trench position 0-10 in A1. X-Wing threads the Death Star trench.

=REPT("โฌ›",A1)&"๐Ÿš€"&REPT("โฌ›",MAX(0,10-A1))&"๐ŸŽฏ"

โฌ›โฌ›โฌ›๐Ÿš€โฌ›โฌ›โฌ›โฌ›โฌ›โฌ›๐ŸŽฏ

Death Star charging laser

REPT

Put charge level 0-5 in A1. Green beams fill before the superlaser fires.

=REPT("๐ŸŸข",A1)&REPT("โšช",5-A1)&" ๐ŸŒ‘"

๐ŸŸข๐ŸŸข๐ŸŸขโšชโšช ๐ŸŒ‘

TIE Fighter swarm

REPT

Put fighter count in A1. Imperial TIEs close on the rebel ship.

=REPT("๐Ÿ›ธ",A1)&" ๐Ÿš€"

๐Ÿ›ธ๐Ÿ›ธ๐Ÿ›ธ ๐Ÿš€

Rebel fleet assembling

REPT MAX

Put ships rallied 0-5 in A1. X-Wings gather before the attack.

=REPT("๐Ÿš€",A1)&REPT("โญ",MAX(0,5-A1))

๐Ÿš€๐Ÿš€๐Ÿš€โญโญ

X-Wing attack run

REPT MAX

Put run progress 0-10 in A1. Stars trail the fighter toward the target.

=REPT("โญ",A1)&"๐Ÿš€"&REPT("ใƒป",MAX(0,10-A1))

โญโญโญ๐Ÿš€ใƒปใƒปใƒปใƒปใƒป

Falcon escaping hyperspace

REPT

Put jump streak 0-5 in A1. Millennium Falcon drops out of lightspeed.

=REPT("โœจ",A1)&"๐Ÿš€๐Ÿ’จ"

โœจโœจโœจ๐Ÿš€๐Ÿ’จ

Droid factory conveyor

REPT

Put assembly progress 0-5 in A1. Gears roll a droid down the line.

=REPT("โš™๏ธ",A1)&"๐Ÿค–"

โš™๏ธโš™๏ธโš™๏ธ๐Ÿค–

Clone army deployed

REPT

Put battalion size in A1. Clone troopers march into battle.

=REPT("๐Ÿช–",A1)&" Clone Army"

๐Ÿช–๐Ÿช–๐Ÿช– Clone Army

Jedi Council approval

REPT

Put council votes 0-5 in A1. Green lights mean the mission is approved.

=REPT("๐ŸŸข",A1)&REPT("โšช",5-A1)

๐ŸŸข๐ŸŸข๐ŸŸขโšชโšช

Sith influence meter

REPT

Put dark-side pull 0-5 in A1. Red overtakes black as the Sith gain ground.

=REPT("๐Ÿ”ด",A1)&REPT("โšซ",5-A1)

๐Ÿ”ด๐Ÿ”ด๐Ÿ”ดโšซโšซ

Holocron unlocked

REPT

Put unlock progress 0-5 in A1. Blue holocron panels light up.

=REPT("๐Ÿ”ท",A1)&REPT("โฌœ",5-A1)

๐Ÿ”ท๐Ÿ”ท๐Ÿ”ทโฌœโฌœ

Kylo Ren rage level

REPT

Put rage level 0-5 in A1. Anger builds in the mask.

=REPT("๐Ÿ’ข",A1)&REPT("โ—‹",5-A1)

๐Ÿ’ข๐Ÿ’ข๐Ÿ’ขโ—‹โ—‹

Darth Vader breathing

REPT

Put breath count in A1. The iconic respirator rhythm.

=REPT("๐Ÿ˜ฎโ€๐Ÿ’จ",A1)

๐Ÿ˜ฎโ€๐Ÿ’จ๐Ÿ˜ฎโ€๐Ÿ’จ๐Ÿ˜ฎโ€๐Ÿ’จ

Force ghost appearance

REPT

Put ghost count in A1. Obi-Wan, Yoda, or Anakin fade in.

=REPT("๐Ÿ‘ป",A1)

๐Ÿ‘ป๐Ÿ‘ป

Ewok trap readiness

REPT

Put trap prep 0-5 in A1. Logs and trees on the forest moon of Endor.

=REPT("๐Ÿชต",A1)&REPT("๐ŸŒฒ",5-A1)

๐Ÿชต๐Ÿชต๐Ÿชต๐ŸŒฒ๐ŸŒฒ

Speeder bike chase

REPT

Put trees passed 0-5 in A1. Scout troopers race through Endor.

=REPT("๐ŸŒฒ",A1)&"๐Ÿ๏ธ"

๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐Ÿ๏ธ

Jabba's treasure pile

REPT

Put hoard size in A1. Gold stacks up beside the Hutt.

=REPT("๐Ÿ’ฐ",A1)&"๐ŸŒ"

๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐ŸŒ

Carbonite thaw

REPT MAX

Put thaw progress 0-10 in A1. Ice melts to reveal Han Solo.

=REPT("๐ŸงŠ",MAX(0,10-A1))&"๐Ÿ‘ค"

๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐ŸงŠ๐Ÿ‘ค

Sarlacc digestion

REPT

Put digestion stage in A1. Teeth at the edge of the Great Pit of Carkoon.

=REPT("๐Ÿฆท",A1)&"๐Ÿ•ณ๏ธ"

๐Ÿฆท๐Ÿฆท๐Ÿฆท๐Ÿ•ณ๏ธ

Boba Fett bounty tracker

REPT

Put targets locked 0-5 in A1. Crosshairs close on the payout.

=REPT("๐ŸŽฏ",A1)&"๐Ÿ’ฐ"

๐ŸŽฏ๐ŸŽฏ๐ŸŽฏ๐Ÿ’ฐ

Mandalorian bounty board

REPT

Put contracts posted in A1. Wanted posters stack up for the hunter.

=REPT("๐Ÿ“œ",A1)&"๐Ÿช™"

๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ๐Ÿช™

Grogu snack count

REPT

Put snack count in A1. Grogu reaches for another egg.

=REPT("๐Ÿฅš",A1)

๐Ÿฅš๐Ÿฅš๐Ÿฅš

Jawa scrap haul

REPT

Put scrap pieces 0-5 in A1. Jawas haul droid parts across the dunes.

=REPT("โš™๏ธ",A1)&"๐ŸคŽ"

โš™๏ธโš™๏ธโš™๏ธ๐ŸคŽ

Sandcrawler inventory

REPT

Put crates loaded in A1. Jawa sandcrawler fills up before rolling out.

=REPT("๐Ÿ“ฆ",A1)&"๐Ÿšš"

๐Ÿ“ฆ๐Ÿ“ฆ๐Ÿ“ฆ๐Ÿšš

Blue milk rating

REPT

Put rating 0-5 in A1. Tatooine blue milk gets a star score.

=REPT("๐Ÿฅ›",A1)&REPT("โ˜†",5-A1)

๐Ÿฅ›๐Ÿฅ›๐Ÿฅ›โ˜†โ˜†

Mos Eisley cantina crowd

REPT

Put crowd energy 0-5 in A1. Band horns and drinks at the cantina bar.

=REPT("๐ŸŽบ",A1)&"๐Ÿบ"

๐ŸŽบ๐ŸŽบ๐ŸŽบ๐Ÿบ

Cantina band intensity

REPT MAX

Put band volume 0-5 in A1. Figrin D'an and the Modal Nodes crank up.

=REPT("๐ŸŽท",A1)&REPT("๐ŸŽบ",MAX(0,5-A1))

๐ŸŽท๐ŸŽท๐ŸŽท๐ŸŽบ๐ŸŽบ

Force push distance

REPT

Put push distance 0-5 in A1. Shockwaves shove the target back.

=REPT("ใ€ฐ๏ธ",A1)&"๐Ÿ‘ค"

ใ€ฐ๏ธใ€ฐ๏ธใ€ฐ๏ธ๐Ÿ‘ค

Jedi meditation

REPT

Put meditation depth in A1. Padawans center themselves in the Force.

=REPT("๐Ÿง˜",A1)

๐Ÿง˜๐Ÿง˜๐Ÿง˜

Lightsaber crystal alignment

CHOOSE

Put number 1-6 in A1 for kyber crystal color.

=CHOOSE(A1,"๐Ÿ”ต","๐ŸŸข","๐ŸŸฃ","๐ŸŸก","โšช","๐Ÿ”ด")

๐Ÿ”ต

Bacta tank recovery

REPT

Put recovery progress 0-5 in A1. Luke heals in the bacta tank.

=REPT("๐Ÿ’™",A1)&REPT("๐Ÿค",5-A1)

๐Ÿ’™๐Ÿ’™๐Ÿ’™๐Ÿค๐Ÿค

Star Destroyer blockade

REPT

Put destroyer count in A1. Imperial ships ring the planet.

=REPT("๐Ÿ›ธ",A1)&"๐Ÿช"

๐Ÿ›ธ๐Ÿ›ธ๐Ÿ›ธ๐Ÿช

Shield generator charging

REPT MAX

Put charge level 0-5 in A1. Endor shield powers up before the battle.

=REPT("๐Ÿ›ก๏ธ",A1)&REPT("โšก",MAX(0,5-A1))

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธโšกโšก

Thermal detonator countdown

Put seconds elapsed 0-10 in A1. Countdown to Leia's thermal detonator.

=10-A1&" ๐Ÿ’ฃ"

7 ๐Ÿ’ฃ

Holo-message transmission

REPT

Put signal strength 0-5 in A1. Leia's distress call beams across space.

=REPT("๐Ÿ“ก",A1)&"๐Ÿ‘ธ"

๐Ÿ“ก๐Ÿ“ก๐Ÿ“ก๐Ÿ‘ธ

Rebel transmission strength

REPT

Put signal bars 0-5 in A1. Rebel comms punch through Imperial jamming.

=REPT("๐Ÿ“ถ",A1)

๐Ÿ“ถ๐Ÿ“ถ๐Ÿ“ถ

Imperial alert level

CHOOSE

Put alert level 1-5 in A1. Death Star goes from green to red alert.

=CHOOSE(A1,"๐ŸŸข","๐ŸŸก","๐ŸŸ ","๐Ÿ”ด","๐Ÿšจ")

๐ŸŸ 

Force balance

REPT

Put light-side score 0-10 in A1. White and black sides of the Force.

=REPT("โšช",A1)&"โš–๏ธ"&REPT("โšซ",10-A1)

โšชโšชโšชโš–๏ธโšซโšซโšซโšซโšซโšซโšซ

Binary sunset blinking

IF MOD NOW

Animates with NOW(). Twin suns blink on Tatooine. No input needed.

=IF(MOD(NOW()*86400,2)=0,"โ˜€๏ธโ˜€๏ธ","๐ŸŒ…")

โ˜€๏ธโ˜€๏ธ

R2-D2 beeping

CHOOSE MOD NOW

Animates with NOW(). R2 cycles through colored indicator lights.

=CHOOSE(MOD(NOW()*86400,4)+1,"๐Ÿค–","๐Ÿค–๐Ÿ”ต","๐Ÿค–๐Ÿ”ด","๐Ÿค–๐ŸŸข")

๐Ÿค–๐Ÿ”ต

Lightsaber flicker

IF MOD NOW

Animates with NOW(). Blade sparks on and off during the duel.

=IF(MOD(NOW()*86400,2)=0,"โš”๏ธโœจ","โš”๏ธ")

โš”๏ธโœจ

Death Star charging

REPT MOD NOW

Animates with NOW(). Superlaser charge pulses on the Death Star.

=REPT("๐ŸŸข",MOD(NOW()*86400,6))&"๐ŸŒ‘"

๐ŸŸข๐ŸŸข๐ŸŸข๐ŸŒ‘

Hyperdrive charging

REPT MOD NOW

Animates with NOW(). Falcon hyperdrive motivator spins up.

=REPT("โœจ",MOD(NOW()*86400,8))&"๐Ÿš€"

โœจโœจโœจโœจ๐Ÿš€

One Ring Mount Doom trek

REPT MAX

Put journey progress 0-10 in A1. The ring closes on the volcano.

=๐Ÿ”๏ธ&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’"&REPT("ใƒป",A1)&"๐ŸŒ‹"

๐Ÿ”๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿ’ใƒปใƒปใƒป๐ŸŒ‹

Fellowship march to Mordor

REPT MAX

Put march progress 0-10 in A1. The fellowship pushes through the wild.

=REPT("๐Ÿง",1)&REPT("๐Ÿง™",1)&REPT("๐Ÿง”",1)&REPT("ใƒป",MAX(0,10-A1))&REPT("๐Ÿ‘ฃ",A1)

๐Ÿง๐Ÿง™๐Ÿง”ใƒปใƒปใƒปใƒปใƒป๐Ÿ‘ฃ๐Ÿ‘ฃ๐Ÿ‘ฃ

Gandalf vs Balrog bridge duel

REPT MAX

Put duel intensity 0-5 in A1. Flames rise on the bridge.

=REPT("๐ŸŒ‰",1)&"๐Ÿง™"&REPT("๐Ÿ”ฅ",A1)&"๐Ÿ‘น"&REPT("๐Ÿ”ฅ",MAX(0,5-A1))

๐ŸŒ‰๐Ÿง™๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ‘น๐Ÿ”ฅ๐Ÿ”ฅ

Helm's Deep battle line

REPT MAX

Put defense strength 0-10 in A1. Shields and arrows hold the wall.

=REPT("๐Ÿ›ก๏ธ",A1)&REPT("๐Ÿน",MAX(0,10-A1))&" ๐Ÿฐ"

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿน๐Ÿน๐Ÿน๐Ÿน ๐Ÿฐ

Rohan cavalry charge

REPT MAX

Put charge progress 0-10 in A1. Riders thunder toward the battle.

=REPT("๐Ÿด",A1)&REPT("ใƒป",MAX(0,10-A1))&"โš”๏ธ"

๐Ÿด๐Ÿด๐Ÿดใƒปใƒปใƒปใƒปใƒปโš”๏ธ

Orc army counter

REPT

Put orc count 0-5 in A1.

=REPT("๐Ÿ‘น",A1)&REPT("โ—‹",5-A1)

๐Ÿ‘น๐Ÿ‘น๐Ÿ‘นโ—‹โ—‹

Uruk-hai squad size

REPT

Put squad size 0-5 in A1.

=REPT("๐Ÿ‘น",A1)&" Uruk-hai"

๐Ÿ‘น๐Ÿ‘น๐Ÿ‘น Uruk-hai

Legolas arrow volley

REPT

Put arrows fired 0-5 in A1.

=REPT("๐Ÿน",A1)&REPT("โ—‹",5-A1)

๐Ÿน๐Ÿน๐Ÿนโ—‹โ—‹

Gimli axe kill count

REPT

Put kill count in A1.

=REPT("๐Ÿช“",A1)&" dwarf kills"

๐Ÿช“๐Ÿช“๐Ÿช“ dwarf kills

Ent march on Isengard

REPT MAX

Put march progress 0-6 in A1. Trees advance on the tower.

=REPT("๐ŸŒณ",A1)&REPT("ใƒป",MAX(0,6-A1))&"๐Ÿฐ"

๐ŸŒณ๐ŸŒณ๐ŸŒณใƒปใƒปใƒป๐Ÿฐ

Great Eagles rescue flight

REPT MAX

Put rescue progress 0-10 in A1. Eagles swoop toward the mountain.

=REPT("ใƒป",MAX(0,10-A1))&"๐Ÿฆ…"&REPT("ใƒป",A1)&"โ›ฐ๏ธ"

ใƒปใƒปใƒปใƒปใƒป๐Ÿฆ…ใƒปใƒปใƒปโ›ฐ๏ธ

Sauron eye gaze intensity

REPT

Put gaze level 0-5 in A1.

=REPT("๐Ÿ‘๏ธ",A1)&REPT("โ—‹",5-A1)

๐Ÿ‘๏ธ๐Ÿ‘๏ธ๐Ÿ‘๏ธโ—‹โ—‹

Palantir vision meter

REPT

Put visions seen 0-5 in A1.

=REPT("๐Ÿ”ฎ",A1)&REPT("โ—‹",5-A1)

๐Ÿ”ฎ๐Ÿ”ฎ๐Ÿ”ฎโ—‹โ—‹

Mithril armor plates

REPT

Put armor plates 0-5 in A1.

=REPT("๐Ÿ›ก๏ธ",A1)&REPT("โ—‹",5-A1)&" mithril"

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธโ—‹โ—‹ mithril

Hobbit second breakfast count

REPT

Put breakfast count in A1.

=REPT("๐Ÿž",A1)&" breakfasts"

๐Ÿž๐Ÿž๐Ÿž breakfasts

Nazgul ringwraith pursuit

REPT MAX

Put pursuit progress 0-10 in A1. Riders close on the ring bearer.

=REPT("ใƒป",A1)&"๐Ÿ‡"&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’"

ใƒปใƒป๐Ÿ‡ใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿ’

Shelob web trap progress

REPT MAX

Put web density 0-8 in A1. Spider closes in the tunnel.

=REPT("๐Ÿ•ธ๏ธ",A1)&REPT("ใƒป",MAX(0,8-A1))&"๐Ÿ•ท๏ธ"

๐Ÿ•ธ๏ธ๐Ÿ•ธ๏ธ๐Ÿ•ธ๏ธใƒปใƒปใƒป๐Ÿ•ท๏ธ

Mines of Moria depth

REPT MAX

Put depth level 0-10 in A1. Deeper into the dark mines.

=REPT("โ›๏ธ",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’€"

โ›๏ธโ›๏ธโ›๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿ’€

Cave troll encounter

REPT

Put troll threat 0-5 in A1.

=REPT("๐Ÿ‘น",A1)&REPT("โ—‹",5-A1)&" troll"

๐Ÿ‘น๐Ÿ‘น๐Ÿ‘นโ—‹โ—‹ troll

Elven star light rating

REPT

Put elven rating 0-5 in A1.

=REPT("โœจ",A1)&REPT("โ˜†",5-A1)&" Elven"

โœจโœจโœจโ˜†โ˜† Elven

Knight vs dragon duel

REPT MAX

Put duel progress 0-5 in A1. Knight closes on the dragon.

=REPT("๐Ÿ›ก๏ธ",1)&REPT("โš”๏ธ",A1)&REPT("ใƒป",MAX(0,5-A1))&"๐Ÿ‰"

๐Ÿ›ก๏ธโš”๏ธโš”๏ธโš”๏ธใƒปใƒป๐Ÿ‰

Dragon treasure hoard

REPT

Put gold piles in A1. Dragon guards the loot.

=REPT("๐Ÿ’ฐ",A1)&REPT("๐Ÿ‰",1)

๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ‰

Dragon fire breath meter

REPT

Put fire intensity 0-5 in A1.

=REPT("๐Ÿ”ฅ",A1)&REPT("โ—‹",5-A1)&"๐Ÿ‰"

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅโ—‹โ—‹๐Ÿ‰

Sword fight intensity

REPT

Put duel level 0-5 in A1.

=REPT("โš”๏ธ",A1)&REPT("โ—‹",5-A1)

โš”๏ธโš”๏ธโš”๏ธโ—‹โ—‹

Castle siege progress

REPT MAX

Put siege progress 0-10 in A1. Arrows rain on the castle.

=REPT("๐Ÿน",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿฐ"

๐Ÿน๐Ÿน๐Ÿนใƒปใƒปใƒปใƒปใƒป๐Ÿฐ

Goblin ambush counter

REPT

Put goblin count in A1.

=REPT("๐Ÿ‘บ",A1)&" goblins"

๐Ÿ‘บ๐Ÿ‘บ๐Ÿ‘บ goblins

Skeleton army march

REPT

Put skeleton count 0-5 in A1.

=REPT("๐Ÿ’€",A1)&REPT("โ—‹",5-A1)

๐Ÿ’€๐Ÿ’€๐Ÿ’€โ—‹โ—‹

Troll bridge toll

REPT

Put troll count under the bridge in A1.

=REPT("๐ŸŒ‰",1)&REPT("๐Ÿ‘น",A1)&" trolls"

๐ŸŒ‰๐Ÿ‘น๐Ÿ‘น๐Ÿ‘น trolls

Unicorn meadow count

REPT

Put unicorn count 0-5 in A1. Flowers fill the meadow.

=REPT("๐Ÿฆ„",A1)&REPT("๐ŸŒธ",5-A1)

๐Ÿฆ„๐Ÿฆ„๐Ÿฆ„๐ŸŒธ๐ŸŒธ

Griffin mountain flight

REPT

Put flight progress 0-10 in A1. Griffin soars toward the peak.

=REPT("๐Ÿฆ…",1)&REPT("ใƒป",A1)&"๐Ÿ”๏ธ"

๐Ÿฆ…ใƒปใƒปใƒป๐Ÿ”๏ธ

Phoenix rebirth flames

REPT

Put rebirth intensity in A1. Flames build to the phoenix.

=REPT("๐Ÿ”ฅ",A1)&"๐Ÿฆ…"

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿฆ…

Hydra head count

REPT

Put heads remaining in A1.

=REPT("๐Ÿ",A1)&" heads"

๐Ÿ๐Ÿ๐Ÿ heads

Werewolf moon howl

REPT

Put howl intensity in A1. Wolves answer the moon.

=REPT("๐Ÿบ",A1)&REPT("๐ŸŒ™",1)

๐Ÿบ๐Ÿบ๐Ÿบ๐ŸŒ™

Vampire bat swarm

REPT

Put bat count 0-5 in A1.

=REPT("๐Ÿฆ‡",A1)&REPT("โ—‹",5-A1)

๐Ÿฆ‡๐Ÿฆ‡๐Ÿฆ‡โ—‹โ—‹

Medusa stone gaze

REPT MAX

Put gaze level 0-3 in A1. Victims turn to stone.

=REPT("๐Ÿ",A1)&"๐Ÿ‘๏ธ"&REPT("๐Ÿชจ",MAX(0,3-A1))

๐Ÿ๐Ÿ๐Ÿ‘๏ธ๐Ÿชจ

Potion brewing progress

REPT CHAR

Put brew progress 0-5 in A1. Vials fill toward the finished potion.

=REPT("๐Ÿงช",A1)&REPT(CHAR(9617),5-A1)&" ๐Ÿง™"

๐Ÿงช๐Ÿงช๐Ÿงชโ–’โ–’ ๐Ÿง™

Spell casting power

REPT

Put mana level 0-5 in A1.

=REPT("โœจ",A1)&REPT("โ—‹",5-A1)&" mana"

โœจโœจโœจโ—‹โ—‹ mana

Dungeon crawl depth

REPT MAX

Put depth 0-10 in A1. Torches lead deeper into the crypt.

=REPT("๐Ÿ•ฏ๏ธ",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ’€"

๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธใƒปใƒปใƒปใƒปใƒป๐Ÿ’€

Enchanted forest path

REPT MAX

Put path progress 0-5 in A1. Trees and fairies line the trail.

=REPT("๐ŸŒฒ",A1)&REPT("โœจ",MAX(0,5-A1))&"๐Ÿงš"

๐ŸŒฒ๐ŸŒฒ๐ŸŒฒโœจโœจ๐Ÿงš

Wizard tower ascent

REPT MAX

Put climb progress 0-10 in A1. Wizard climbs toward the tower top.

=REPT("ใƒป",MAX(0,10-A1))&"๐Ÿง™"&REPT("ใƒป",A1)&"๐Ÿ—ผ"

ใƒปใƒปใƒปใƒปใƒป๐Ÿง™ใƒปใƒปใƒป๐Ÿ—ผ

Quest scroll tracker

REPT

Put quests completed 0-3 in A1.

=REPT("๐Ÿ“œ",A1)&REPT("โ—‹",3-A1)&" quests"

๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ quests

Tavern ale rating

REPT MIN

Put ale mugs in A1. More mugs, better night at the tavern.

=REPT("๐Ÿบ",A1)&REPT("โญ",MIN(A1,5))

๐Ÿบ๐Ÿบ๐Ÿบโญโญโญ

Treasure chest loot count

REPT

Put gems found in A1.

=REPT("๐Ÿ’Ž",A1)&REPT("๐Ÿ“ฆ",1)

๐Ÿ’Ž๐Ÿ’Ž๐Ÿ’Ž๐Ÿ“ฆ

Battle axe squad

REPT

Put axe count 0-5 in A1.

=REPT("๐Ÿช“",A1)&REPT("โ—‹",5-A1)

๐Ÿช“๐Ÿช“๐Ÿช“โ—‹โ—‹

Shield wall formation

REPT

Put shield count 0-5 in A1.

=REPT("๐Ÿ›ก๏ธ",A1)&REPT("โ—‹",5-A1)

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธโ—‹โ—‹

War camp fire intensity

REPT MAX

Put campfire level in A1. Tents ring the flames.

=REPT("โ›บ",A1)&REPT("๐Ÿ”ฅ",MAX(0,5-A1))

โ›บโ›บโ›บ๐Ÿ”ฅ๐Ÿ”ฅ

Elven vs orc battle meter

REPT

Put elven strength 0-5 in A1. Elves push back the orcs.

=REPT("๐Ÿง",A1)&REPT("๐Ÿ‘น",5-A1)

๐Ÿง๐Ÿง๐Ÿง๐Ÿ‘น๐Ÿ‘น

Hero or villain alignment

IF

Put alignment score 0-5 in A1. Over 3 means hero.

=IF(A1>3,"๐Ÿฆธ Hero","๐Ÿ‘น Villain")

๐Ÿฆธ Hero

Fantasy weapon picker

CHOOSE

Put number 1-5 in A1 for weapon type.

=CHOOSE(A1,"โš”๏ธ Sword","๐Ÿน Bow","๐Ÿช“ Axe","๐Ÿ”ฎ Staff","๐Ÿ›ก๏ธ Shield")

โš”๏ธ Sword

Dragon slayer victory

IF

Put slayer power 0-10 in A1. Over 5 means the dragon falls.

=IF(A1>5,"โš”๏ธ Dragon slain","๐Ÿ‰ Dragon wins")

โš”๏ธ Dragon slain

Mermaid lagoon count

REPT

Put mermaid count 0-5 in A1. Waves fill the lagoon.

=REPT("๐Ÿงœ",A1)&REPT("๐ŸŒŠ",5-A1)

๐Ÿงœ๐Ÿงœ๐Ÿงœ๐ŸŒŠ๐ŸŒŠ

Kraken tentacle attack

REPT MAX

Put tentacle count in A1. Tentacles rise from the deep.

=REPT("๐Ÿ™",A1)&REPT("๐ŸŒŠ",MAX(0,3-A1))

๐Ÿ™๐Ÿ™๐Ÿ™

Cyclops boulder throw

REPT MAX

Put throw distance 0-10 in A1. Boulders fly toward the target.

=REPT("๐Ÿ‘๏ธ",1)&REPT("๐Ÿชจ",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐ŸŽฏ"

๐Ÿ‘๏ธ๐Ÿชจ๐Ÿชจ๐Ÿชจใƒปใƒปใƒปใƒปใƒป๐ŸŽฏ

Fairy dust sparkle trail

REPT MAX

Put sparkle level 0-10 in A1. Fairy leaves a glitter trail.

=REPT("๐Ÿงš",1)&REPT("โœจ",A1)&REPT("ใƒป",MAX(0,10-A1))

๐Ÿงšโœจโœจโœจโœจใƒปใƒปใƒปใƒปใƒป

Excalibur drawn from the stone

REPT MAX

Put pull strength 0-10 in A1. Sword rises from the stone.

=REPT("๐Ÿชจ",MAX(0,10-A1))&"โš”๏ธ"&REPT("โœจ",A1)

๐Ÿชจ๐Ÿชจ๐Ÿชจ๐Ÿชจโš”๏ธโœจโœจโœจโœจโœจโœจ

King Arthur's round table

REPT

Put knights seated 0-8 in A1.

=REPT("๐Ÿ›ก๏ธ",A1)&" ๐Ÿฐ"

๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ๐Ÿ›ก๏ธ ๐Ÿฐ

Dwarf gold mine

REPT MAX

Put gold collected 0-10 in A1.

=REPT("โ›๏ธ",A1)&REPT("๐Ÿ’ฐ",MAX(0,10-A1))

โ›๏ธโ›๏ธโ›๏ธ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ๐Ÿ’ฐ

Magic portal opening

REPT

Put portal power 0-5 in A1.

=REPT("๐ŸŒ€",A1)&REPT("โ—‹",5-A1)

๐ŸŒ€๐ŸŒ€๐ŸŒ€โ—‹โ—‹

Necromancer army raised

REPT MAX

Put skeleton count 0-5 in A1.

=REPT("๐Ÿ’€",A1)&REPT("โšฐ๏ธ",MAX(0,5-A1))

๐Ÿ’€๐Ÿ’€๐Ÿ’€โšฐ๏ธโšฐ๏ธ

Dark tower corruption

REPT

Put corruption level 0-5 in A1.

=REPT("โšซ",A1)&REPT("โšช",5-A1)&" ๐Ÿฐ"

โšซโšซโšซโšชโšช ๐Ÿฐ

Wizard spellbook mastery

REPT MAX

Put spells learned 0-10 in A1.

=REPT("๐Ÿ“–",A1)&REPT("โœจ",MAX(0,10-A1))

๐Ÿ“–๐Ÿ“–๐Ÿ“–โœจโœจโœจโœจโœจโœจโœจ

Magic wand charge

REPT

Put charge level 0-5 in A1.

=REPT("โœจ",A1)&REPT("โšช",5-A1)&"๐Ÿช„"

โœจโœจโœจโšชโšช๐Ÿช„

Crystal ball clarity

REPT

Put vision strength 0-5 in A1.

=REPT("๐Ÿ”ฎ",A1)&REPT("๐ŸŒซ๏ธ",5-A1)

๐Ÿ”ฎ๐Ÿ”ฎ๐Ÿ”ฎ๐ŸŒซ๏ธ๐ŸŒซ๏ธ

Treasure map completion

REPT

Put clues found 0-5 in A1.

=REPT("๐Ÿ—บ๏ธ",A1)&REPT("โ“",5-A1)

๐Ÿ—บ๏ธ๐Ÿ—บ๏ธ๐Ÿ—บ๏ธโ“โ“

Dungeon boss approach

REPT MAX

Put room progress 0-10 in A1.

=REPT("๐Ÿšช",A1)&REPT("ใƒป",MAX(0,10-A1))&"๐Ÿ‘น"

๐Ÿšช๐Ÿšช๐Ÿšชใƒปใƒปใƒปใƒปใƒปใƒปใƒป๐Ÿ‘น

Mimic suspicion level

REPT MAX

Put suspicion 0-5 in A1.

=REPT("๐Ÿ“ฆ",A1)&REPT("๐Ÿ˜ˆ",MAX(0,5-A1))

๐Ÿ“ฆ๐Ÿ“ฆ๐Ÿ“ฆ๐Ÿ˜ˆ๐Ÿ˜ˆ

Bard inspiration meter

REPT

Put inspiration 0-5 in A1.

=REPT("๐ŸŽต",A1)&REPT("โ—‹",5-A1)

๐ŸŽต๐ŸŽต๐ŸŽตโ—‹โ—‹

Tavern quest rumors

REPT MAX

Put rumors heard 0-5 in A1.

=REPT("๐Ÿบ",A1)&REPT("๐Ÿ“œ",MAX(0,5-A1))

๐Ÿบ๐Ÿบ๐Ÿบ๐Ÿ“œ๐Ÿ“œ

Rogue stealth level

REPT

Put stealth level 0-5 in A1.

=REPT("๐Ÿ—ก๏ธ",A1)&REPT("๐ŸŒ‘",5-A1)

๐Ÿ—ก๏ธ๐Ÿ—ก๏ธ๐Ÿ—ก๏ธ๐ŸŒ‘๐ŸŒ‘

Ranger tracking progress

REPT MAX

Put tracks found 0-10 in A1.

=REPT("๐Ÿ‘ฃ",A1)&REPT("๐ŸŒฒ",MAX(0,10-A1))

๐Ÿ‘ฃ๐Ÿ‘ฃ๐Ÿ‘ฃ๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ๐ŸŒฒ

Enchanted sword power

REPT MAX

Put enchantment level 0-5 in A1.

=REPT("โš”๏ธ",A1)&REPT("โœจ",MAX(0,5-A1))

โš”๏ธโš”๏ธโš”๏ธโœจโœจ

Dungeon key collection

REPT MAX

Put keys found 0-5 in A1.

=REPT("๐Ÿ—๏ธ",A1)&REPT("๐Ÿšช",MAX(0,5-A1))

๐Ÿ—๏ธ๐Ÿ—๏ธ๐Ÿ—๏ธ๐Ÿšช๐Ÿšช

Dragon egg hatch progress

REPT MAX

Put hatch progress 0-10 in A1.

=REPT("๐Ÿฅš",MAX(0,10-A1))&"๐Ÿฃ"&REPT("๐Ÿ”ฅ",A1)

๐Ÿฅš๐Ÿฅš๐Ÿฅš๐Ÿฅš๐Ÿฃ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ

Pegasus flight distance

REPT MAX

Put flight progress 0-10 in A1.

=REPT("โ˜๏ธ",A1)&"๐Ÿฆ„"&REPT("โ˜๏ธ",MAX(0,10-A1))

โ˜๏ธโ˜๏ธโ˜๏ธ๐Ÿฆ„โ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธโ˜๏ธ

Treasure chest lockpick

REPT

Put lockpick progress 0-5 in A1.

=REPT("๐Ÿ—๏ธ",A1)&REPT("๐Ÿ”’",5-A1)

๐Ÿ—๏ธ๐Ÿ—๏ธ๐Ÿ—๏ธ๐Ÿ”’๐Ÿ”’

Dungeon torch supply

REPT

Put torches remaining 0-5 in A1.

=REPT("๐Ÿ”ฅ",A1)&REPT("๐Ÿ•ฏ๏ธ",5-A1)

๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ•ฏ๏ธ๐Ÿ•ฏ๏ธ

Magic academy grades

CHOOSE

Put rank 1-5 in A1.

=CHOOSE(A1,"๐Ÿงน Apprentice","๐Ÿ“– Student","๐Ÿช„ Mage","๐Ÿ”ฎ Wizard","๐Ÿง™ Archmage")

๐Ÿง™ Archmage

Alignment meter

REPT

Put alignment 0-5 in A1.

=REPT("๐Ÿ˜‡",A1)&REPT("๐Ÿ˜ˆ",5-A1)

๐Ÿ˜‡๐Ÿ˜‡๐Ÿ˜‡๐Ÿ˜ˆ๐Ÿ˜ˆ

Quest completion tracker

REPT MAX

Put quests completed 0-10 in A1.

=REPT("โœ…",A1)&REPT("๐Ÿ“œ",MAX(0,10-A1))

โœ…โœ…โœ…๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ๐Ÿ“œ

Loot rarity picker

CHOOSE

Put rarity 1-5 in A1.

=CHOOSE(A1,"โšช Common","๐ŸŸข Uncommon","๐Ÿ”ต Rare","๐ŸŸฃ Epic","๐ŸŸ  Legendary")

๐ŸŸฃ Epic

Boss battle health bar

REPT

Put health 0-10 in A1.

=REPT("โค๏ธ",A1)&REPT("๐Ÿ–ค",10-A1)&" ๐Ÿ‘น"

โค๏ธโค๏ธโค๏ธโค๏ธ๐Ÿ–ค๐Ÿ–ค๐Ÿ–ค๐Ÿ–ค๐Ÿ–ค๐Ÿ–ค ๐Ÿ‘น

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons