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.

Download Excel Add-in

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.

FeatureNative Excel MethodsXLclick Extract Numbers
Ease of useFormulas and multiple stepsOne-click extraction workflow
Mixed text and numbersRequires custom formulas or transformationsAutomatically extracts numeric values
Decimal numbersRequires careful formula design and formattingOptional decimal extraction
Output locationOften needs helper columns and copyingNew column, selected cells, or new sheet
Original dataSome workflows risk overwriting existing cellsPreserve source data by choosing a new sheet
Result previewManual inspection of formula outputLive 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

Extract Numbers Settings

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.

Author Image
Federico Magni SEO Specialist since 2012

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.