How to Extract Numbers from Text in Excel
Getting the numbers out of "$1,234.50" or "Item 12 / 6-pack" usually means the dreaded TEXTJOIN-MID-ROW array formula — gnarly to read and 365-only. Here's why, and the one-click way.
Last updated: August 2026
| Before | After | |
|---|---|---|
| $1,234.50 | → | 1234.5 (real number) |
| Item 12 / 6-pack | → | 12 6 |
Why the array formula is gnarly
The standard trick strings together TEXTJOIN, MID and ROW into an array formula that inspects every character of the cell and keeps the digits. It's notoriously hard to read, easy to break when you copy it wrong, and it only works in Microsoft 365 — so it fails on older Excel and many managed installs. For a job this common, that's a lot of fragile machinery.
The 1-click way — Tellsheet's Extract Numbers
Select the column and run Extract Numbers. It pulls the numeric content from each cell — when a cell holds a single number the result is a real number you can sum and sort, so "$1,234.50" becomes 1234.5. Cells with no digits are left alone, and cells with several numbers keep them all. No array formula, works on any Excel version. Pairs with Convert Text to Number and Extract Text.
Frequently asked questions
Does the result become a real number?
Yes when the cell has a single number — "$1,234.50" becomes 1234.5, ready to sum and sort.
What about cells with no digits?
They're left untouched, not blanked. Only cells containing digits are changed.
Can it pull several numbers?
Yes — "Item 12 / 6-pack" gives "12 6", each run of digits kept and space-separated.
Why not the array formula?
The TEXTJOIN-MID-ROW trick is hard to read, brittle, and 365-only. Extract Numbers does it in one click on any version.
Related Excel guides
Extract numbers in one click
Extract Numbers pulls the numeric content from mixed text — a single number becomes a real number, and digit-free cells are left alone.
Get Tellsheet free See pricing