How to Extract Text from a Cell in Excel
Getting just the number, or the part before a dash, out of a messy cell usually means nesting FIND and LEN inside LEFT or MID — a different fragile formula for every case. Here's why, and the one-click way.
Last updated: August 2026
| Before | After | |
|---|---|---|
| Order #4471 - paid | → | 4471 (numbers) |
| Order #4471 - paid | → | Order #4471 (before ' - ') |
Why the formulas are brittle
To pull a slice out of a cell you reach for LEFT, RIGHT or MID — but each one needs a character position, so you end up nesting FIND and LEN to work out where the delimiter is. That's a different formula for the number, for the text before a dash, and for the last few characters, and every one of them breaks the moment the delimiter moves or a stray space creeps in.
The 1-click way — Tellsheet's Extract Text
Select the column and run Extract Text. Pick a mode — keep just the numbers, the text before or after a delimiter, or the first or last N characters — and it applies to every cell at once, finding the delimiter per row so it never slices in the wrong place. No nested FIND, no formula to copy down. Pairs with Extract Numbers and Regex Extract.
Frequently asked questions
Can I keep only the numbers?
Yes — one mode keeps just the numeric content, so "Order #4471 - paid" becomes "4471".
Can I get the text before or after a character?
Yes — give the delimiter and Extract Text returns everything up to it or after it.
Why is LEFT with FIND unreliable?
The position is hard-coded to where the delimiter sits, so it slices wrong when the delimiter moves. Extract Text finds it per cell.
Does it change the original cells?
It works in place on your selection. Keep a copy first if you want the original text alongside the result.
Related Excel guides
Extract text in one click
Extract Text keeps the numbers, the part before or after a delimiter, or the first or last N characters of every cell — no nested formulas.
Get Tellsheet free See pricing