Remove Text from Numbers in Excel Fast
Need to remove text from numbers in Excel? You can extract numeric values manually using Excel’s built-in formulas and tools, or get the job done in one click with XLclick Extract Numbers.
Whether you're cleaning product codes, prices, measurements, or imported data, discover free Excel methods and learn how to extract numbers without unnecessary manual work.
Excel vs. XLclick: The Easiest Way to Extract Numbers
Excel offers several ways to separate numbers from text, but many require formulas, helper columns, or extra cleanup. XLclick simplifies the process with a dedicated extraction tool and flexible output options.
| Feature | Native Excel Methods | XLclick Extract Numbers |
|---|---|---|
| Ease of use | Formulas and multiple steps | One-click extraction workflow |
| Mixed text and numbers | Requires custom formulas or transformations | Automatically extracts numeric values |
| Decimal numbers | Requires careful formula design and formatting | Optional decimal extraction |
| Output location | Often needs helper columns and copying | New column, selected cells, or new sheet |
| Original data | Some workflows risk overwriting existing cells | Preserve source data by choosing a new sheet |
| Result preview | Manual inspection of formula output | Live preview of the first five results |
The key difference: Excel's native methods are useful for specific patterns and occasional tasks. XLclick is designed to make repetitive data cleaning faster, with fewer manual steps and a simple way to keep your original data intact.
Free Methods to Remove Text and Keep Numbers in Excel
You don't need an add-in to extract numbers from Excel cells. The right approach depends on your Excel version and whether your data contains simple patterns, mixed characters, or decimal values.
1. Use Excel Formulas to Extract Numeric Values
Formulas can separate numbers from text when you know how your data is structured. In Microsoft 365, dynamic array functions and newer text functions can help build custom extraction formulas.
How to do it:
1. Add a helper column beside your original data.
2. Create a formula suited to the structure of your cells.
3. Fill the formula down for the remaining rows.
4. Review the results and copy them as values if necessary.
Important limitation: Extracting every digit from arbitrary text is more complicated than removing a fixed word or character. Numbers separated by spaces, multiple numeric groups, negative signs, and decimal separators may require advanced formulas. A formula that works for one pattern may fail on another.
2. Try Flash Fill for Simple Patterns
Excel's Flash Fill can recognize patterns based on examples you provide. It's useful when you want to extract a number from consistently formatted text without writing a formula.
How to do it:
1. Enter the desired numeric result next to the first source cell.
2. Start entering the next result to establish the pattern.
3. Go to Data > Flash Fill, or press Ctrl + E.
4. Check the generated values before using them.
Important limitation: Flash Fill relies on recognizable patterns rather than a universal numeric extraction rule. It may struggle with inconsistent source data, and its results are static rather than dynamically recalculated like formulas.
3. Use Find and Replace for Predictable Text
If every cell contains the same unwanted word or symbol, Excel's Find and Replace feature can remove it quickly.
How to do it:
1. Select the relevant cells.
2. Press Ctrl + H.
3. Enter the text or character you want to remove.
4. Leave the replacement field empty and click Replace All.
Important limitation: This method removes specified text, not all non-numeric characters automatically. It won't reliably isolate numbers from complex mixed strings, and replacing characters in the wrong range can damage your data. Always review the selected range first.
XLclick Extract Numbers
Mixed text and numbers in the same Excel cell? Extract Numbers strips away all the surrounding text and pulls out only the numeric values — clean and ready to calculate.
Essential Settings for Extract Numbers

To open Extract Numbers, go to the XLclick tab, find the Fix and Clean group, then click Extract > Numbers.
The panel walks you through three steps:
1. SELECT DATA — Click Select and highlight the cells containing your mixed text-and-number data.
2. CLEANING OPTIONS — Enable Also extract decimal numbers (. or ,) to retain values like 29.99 or 1,500 as proper decimals. Leave unchecked to extract integers only.
3. DESTINATION — Choose where to send the extracted numbers:
- Write results in a new column to the right — keeps your original data intact.
- Overwrite selected cells — replaces the source range with the clean numbers.
- Write results to a new sheet — outputs results on a fresh tab.
The LIVE PREVIEW shows the first 5 results before you commit. Click Extract Numbers to run, or Cancel to exit.
Real-World Scenarios: Top Use Cases for Excel Extract Numbers
An E-Commerce Manager Cleaning Scraped Product Prices That Won't Calculate
An e-commerce manager copy-pasted a competitor's product list from the web into Excel. Every price cell read something like Price: $29.99 — mixing label and value in one cell. Excel treated them all as text, so totals, averages, and margin calculations returned errors.
Extract Numbers with Also extract decimal numbers enabled stripped the labels instantly. Clean numeric values landed in a new column, and the calculations started working immediately.
A Freelance Bookkeeper With Invoice Exports Full of Text-Wrapped Amounts
A freelance bookkeeper received monthly invoice exports where every amount came through as Total: 1500 or Amount due: 320 — text strings that couldn't be summed in Excel. Manually extracting each number from hundreds of rows would have taken hours every month.
She selected the full column and ran Extract Numbers with the decimal option on. Clean values went to a new column to the right, ready to sum and report on immediately.
A Marketing Analyst Cleaning Survey Scores Mixed With Text Labels
A marketing analyst downloaded survey data where scores were written as Score: 8 or Rating 4/10. She needed to average results across hundreds of responses, but Excel couldn't calculate anything — the cells were plain text with numbers buried inside them.
Running Extract Numbers pulled the numeric scores out in seconds. Using Write results to a new sheet gave her a clean dataset to pivot and chart without touching the original export.
A Small Business Owner With Inventory Quantities That Wouldn't Sum
A small business owner received a supplier file where every quantity was written as 150 units or Qty: 48. The SUM formula returned zero because Excel treated all values as text. Retyping 300 rows manually was not a realistic option.
Extract Numbers pulled all quantities into a new column to the right in seconds. Stock totals and reorder calculations worked perfectly from that point on.
An Agency Analyst With Ad Spend Figures Locked Inside Text Strings
A digital agency analyst pulled Facebook Ads export data into Excel. The budget column showed values like Spent: $1,240.50 — completely unusable for calculations across 12 months of campaign data and multiple clients.
With Extract Numbers and Also extract decimal numbers enabled, every spend figure was extracted accurately to a new sheet, which became the clean source for all monthly client performance reports.
Excel has always been my laboratory. After years of navigating data-heavy workflows, I created XLclick: the definitive add-in that simplifies complex analysis into a single click. It’s built for pros who want to spend less time on spreadsheets and more time on strategy.