Truncate Long Text with an Ellipsis

Excel Formulas › Data Cleaning

All versionsLEFT

Trim long text to a fixed length for tidy reports and labels, adding "…" only when it’s actually shortened. Short entries stay untouched.

Quick formula: shorten text past N characters:
=IF(LEN(A2) > n, LEFT(A2, n) & "…", A2)
If longer than N, take the first N characters and add an ellipsis; otherwise keep the text as-is.

Functions used (tap for the full reference guide):

LEFTLEN

The example

Long titles clipped to 20 chars.

AB
1TextClipped
2A very long title hereA very long title he…

The formula

The formula:

=IF(LEN(A2) > n, LEFT(A2, n) & "…", A2) // clip and add … if needed

How it works

How it works:

  1. LEN(A2) > n tests whether the text actually exceeds the limit.
  2. If so, LEFT(A2, n) & "…" takes the first N characters and appends an ellipsis.
  3. If not, the original text is returned unchanged — no needless ….
  4. Break on a word boundary by finding the last space within the limit for cleaner clips.

Clip on a space for readability. Cutting mid-word looks rough. LEFT(A2, FIND("~", SUBSTITUTE(A2, " ", "~", …)))-style tricks find the last space before the limit so the ellipsis lands between words. For dashboards, plain character-count clipping is usually fine; for prose, word-boundary clipping reads better.

Try it: interactive demo

Live demo

Text and max length.

Result:

Variations

No ellipsis

Hard clip:

=LEFT(A2, n)

Show remaining count

+N more:

=LEFT(A2,n) & "… (+" & LEN(A2)-n & ")"

Word-safe clip

Last space:

=LEFT(A2, FIND("¬", SUBSTITUTE(LEFT(A2,n)," ","¬", LEN(LEFT(A2,n))-LEN(SUBSTITUTE(LEFT(A2,n)," ","")))) )

Pitfalls & errors

Only clip when needed. The IF avoids adding … to short text.

Ellipsis counts. The result is N+1 characters with the … — reduce N if a hard cap matters.

Mid-word cuts. Use word-boundary clipping for prose.

Practice workbook

📊
Download the free Truncate Long Text with an Ellipsis practice workbook
A truncate sheet with the hard-clip, remaining-count, and word-safe variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I truncate text with an ellipsis in Excel?
Use =IF(LEN(A2) > n, LEFT(A2, n) & "…", A2) so only over-length text gets clipped.
How do I avoid cutting mid-word?
Find the last space within the limit and clip there, so the ellipsis lands between words.
How do I show how much was cut?
Append the overflow: =LEFT(A2,n) & "… (+" & LEN(A2)-n & ")".

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Split text · Char count no spaces · Repeat text bars

Function references: LEFTLEN