- In short
- Finds the first number in each cell and writes it to a new column on the right, kept as text. Both comma and dot decimal styles are supported. Long identity numbers and phone numbers are left untouched so they do not lose digits. A new column with numbers. Nothing in the source moves; a single Undo Last reverses the whole run.
What it is for
Extract Number is used to extract numbers from text.
When to use it
Most useful when you need to separate quantities/code numbers from mixed text.
Example scenarios
- Separate quantities/code numbers from mixed text.
What it needs
A single text column and an options dialog. Supported data types: text, number, date (by selection).
How to use it
- Select the range to extract from.
- On the XLMind Data tab, open the Quick Extract menu in the Extract group and choose Extract Number.
- Tune the choices in the dialog before confirming.
- Confirm; a new column with numbers.
What it produces
A new column with numbers.
Effect on your data and undo
Extract Number does not change your source data; the result is added as a separate item. Undo Last reverses it whenever you need.
How it differs from similar tools
It works without formulas and never touches the source range; the result is produced separately, so the original table keeps its formulas intact.
Good to know
No special preconditions.
Limitations
No special preconditions.
Frequently asked questions
- Where will I see the result?
- A new column with numbers.
- What happens to invalid or unexpected values?
- Text-safe.
- How are blank cells handled?
- No-match → blank.
- Does the result stay linked to the source?
- The result is a snapshot of the data at run time; after bigger edits, run the tool again for a current view.
- Any known limits?
- No special preconditions.
Works well with
- Before you start, consider Extract URL
- To keep working on the result, use Take Left
- As a complement, use Trim & Clean
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.