All Progress Bars Ratings Scenes Status Timers Pickers Layout Counters Writing Star Wars Lord of the Rings Gamers Kawaii Cozy Bullet Journal D&D Vaporwave Arts & Crafts Fantasy Sports Gym Money Habits Sales School Pokémon Holidays

Box borders, dividers, and callout frames without merging cells.

Box border cell

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

="┌"&REPT("─",A1)&"┐"&CHAR(10)&"│"&REPT(" ",A1)&"│"&CHAR(10)&"└"&REPT("─",A1)&"┘"

┌────┐ │ │ └────┘

REPT CHAR

Comma list to line breaks

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

REGEXREPLACE CHAR

Comma list to numbered lines

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

TEXTJOIN SEQUENCE SPLIT CHAR

Comma list to dash lines

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

REGEXREPLACE CHAR

Comma list to arrow lines

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

CHAR REGEXREPLACE

Comma list to double-spaced lines

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

REGEXREPLACE CHAR

Pipe list to line breaks

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

REGEXREPLACE CHAR

Text with underline

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

=A1&CHAR(10)&REPT("─",LEN(A1))

Title ─────

LEN REPT CHAR

Centered text in cell

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

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

Hello

REPT LEN

Right-aligned text in cell

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

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

Hi

REPT LEN

Section title with rules

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

=REPT("═",A1)&CHAR(10)&B1&CHAR(10)&REPT("═",A1)

════════ Notes ════════

REPT CHAR

Table row with pipes

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

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

| Name | Qty | Price |

LEN

Table column header line

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

="├"&REPT("─",LEN(A1)+2)&"┤"&CHAR(10)&"│ "&A1&" │"

├─────┤ │ Qty │

LEN REPT CHAR

Grid top border

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

="┌"&REPT("─",A1)&"┬"&REPT("─",B1)&"┐"

┌───┬───┐

REPT

Grid middle row

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

="├"&REPT("─",A1)&"┼"&REPT("─",B1)&"┤"

├───┼───┤

REPT

Left T divider

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

=REPT("─",A1)&"├"&REPT("─",A1)

────├────

REPT

Right T divider

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

=REPT("─",A1)&"┤"&REPT("─",A1)

────┤────

REPT

L-shaped corner

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

="└"&REPT("─",A1)

└────

REPT

Three-line menu icon

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

=REPT("═",A1)&CHAR(10)&REPT("═",A1)&CHAR(10)&REPT("═",A1)

═══ ═══ ═══

REPT CHAR

Bracket label wrap

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

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

[ Hello ]

LEN

Curly quote wrap

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

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

“Hello”

CHAR

Ellipsis truncate

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...

IF LEN LEFT

Surround by ASCII

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 ╚═══════╝

REPT LEN CHAR

Rounded border cell

Put inner width in A1. Box with rounded corners.

="╭"&REPT("─",A1)&"╮"&CHAR(10)&"│"&REPT(" ",A1)&"│"&CHAR(10)&"╰"&REPT("─",A1)&"╯"

╭────╮ │ │ ╰────╯

REPT CHAR

Heavy border cell

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

="┏"&REPT("━",A1)&"┓"&CHAR(10)&"┃"&REPT(" ",A1)&"┃"&CHAR(10)&"┗"&REPT("━",A1)&"┛"

┏━━━━┓ ┃ ┃ ┗━━━━┛

REPT CHAR

Text inside box

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 │ └────┘

LEN REPT CHAR

Text inside double box

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 ║ ╚═══════╝

LEN REPT CHAR

Header box

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

="┏"&REPT("━",LEN(A1)+2)&"┓"&CHAR(10)&"┃ "&A1&" ┃"

┏━━━━━━━┓ ┃ Title ┃

LEN REPT CHAR

Side border panel

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)&"│"

│ │ │ │ │ │

REPT CHAR

Horizontal rule

Put width in A1. Single row of light dashes.

=REPT("─",A1)

────────

REPT

Dashed horizontal rule

Put width in A1. Dotted horizontal line.

=REPT("┄",A1)

┄┄┄┄┄┄┄┄

REPT

Vertical divider

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

=REPT("│"&CHAR(10),A1-1)&"│"

│ │ │ │

REPT CHAR

T-section divider

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

=REPT("─",A1)&"┬"&REPT("─",A1)

────┬────

REPT

Cross divider

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

=REPT("─",A1)&"┼"&REPT("─",A1)

────┼────

REPT

ASCII billboard

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 │ └───┴──┘ │ │

LEN REPT CHAR

Goal posts

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 │ ─┴────────┴─

LEN REPT CHAR

Hanging sign

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 │ └──────┘

LEN REPT CHAR

Surround text with skulls

Put text in A1. Skull rows above and below with skulls on each side. Turn on Wrap text.

=REPT("💀",LEN(A1)+2)&CHAR(10)&"💀 "&A1&" 💀"&CHAR(10)&REPT("💀",LEN(A1)+2)

💀💀💀💀💀 💀 hi 💀 💀💀💀💀💀

REPT LEN CHAR

Surround text with warning signs

Put text in A1. Warning rows above and below with signs on each side. Turn on Wrap text.

=REPT("⚠️",LEN(A1)+2)&CHAR(10)&"⚠️ "&A1&" ⚠️"&CHAR(10)&REPT("⚠️",LEN(A1)+2)

⚠️⚠️⚠️⚠️⚠️ ⚠️ hi ⚠️ ⚠️⚠️⚠️⚠️⚠️

REPT LEN CHAR

Surround text with hearts

Put text in A1. Heart rows above and below with hearts on each side. Turn on Wrap text.

=REPT("❤️",LEN(A1)+2)&CHAR(10)&"❤️ "&A1&" ❤️"&CHAR(10)&REPT("❤️",LEN(A1)+2)

❤️❤️❤️❤️❤️ ❤️ hi ❤️ ❤️❤️❤️❤️❤️

REPT LEN CHAR

Surround text with flames

Put text in A1. Flame rows above and below with flames on each side. Turn on Wrap text.

=REPT("🔥",LEN(A1)+2)&CHAR(10)&"🔥 "&A1&" 🔥"&CHAR(10)&REPT("🔥",LEN(A1)+2)

🔥🔥🔥🔥🔥 🔥 hi 🔥 🔥🔥🔥🔥🔥

REPT LEN CHAR

Upside down text with CHAR

Put text in A1. Each letter maps to an upside-down Unicode character with CHAR(), then the string reverses. Rotate the sheet 180° to read it.

=TEXTJOIN("",TRUE,MAP(SEQUENCE(LEN(A1)),LAMBDA(i,SWITCH(MID(A1,LEN(A1)-i+1,1),"a",CHAR(592),"b","q","c",CHAR(596),"d","p","e",CHAR(477),"f",CHAR(607),"g",CHAR(387),"h",CHAR(613),"i",CHAR(7425),"j",CHAR(638),"k",CHAR(670),"l","l","m",CHAR(623),"n","u","o","o","p","d","q","b","r",CHAR(633),"s","s","t",CHAR(647),"u","n","v",CHAR(652),"w",CHAR(653),"x","x","y",CHAR(654),"z","z","A",CHAR(8704),"C",CHAR(390),"E",CHAR(398),"F",CHAR(8498),"L",CHAR(741),"M","W","P","d","T",CHAR(8868),"U",CHAR(8745),"V",CHAR(923),"Y",CHAR(8516),"0","0","1",CHAR(406),"2",CHAR(8586),"3",CHAR(8587),"5",CHAR(987),"6","9","7",CHAR(12581),"9","6",".",CHAR(729),"!",CHAR(161),"?",CHAR(191),"(",")",")","(",MID(A1,LEN(A1)-i+1,1)))))

ollǝɥ

CHAR MAP TEXTJOIN SEQUENCE SWITCH LAMBDA MID LEN

Related formula guides

Go deeper with Better Sheets

Members get full courses on CHAR, REPT, and dashboard design, plus hundreds of Google Sheets tutorials. Copy-paste formulas here stay free.

Unlock playground
Ads keep the free stuff free. Members browse ad-free — log in or see pricing.

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

Explore

Academy

Tools

Add ons

Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.