- In short
- Finds phone numbers in your text and writes them to a new column on the right. Common local and international formats are supported. Leading zeros are kept and the result stays as text, so the numbers are not changed. Your original column is left as it is. A new column with phone numbers. Your source data stays unchanged; Undo Last brings it back if needed.
What it is for
Extract Phone is used to extract phone numbers from text.
When to use it
Typical use: collect phone numbers from free text.
Example scenarios
- Collect phone numbers from free 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 Phone.
- Pick the settings you need in the window that opens.
- Confirm; a new column with phone numbers.
What it produces
A new column with phone numbers.
Effect on your data and undo
Extract Phone does not change your source data; the result is added as a separate item. Undo Last rolls the change back in a single step.
How it differs from similar tools
No helper formulas are needed; the source area is read but never written, and the output is produced on its own.
Good to know
No special preconditions.
Limitations
No special preconditions.
Frequently asked questions
- Where will I see the result?
- A new column with phone 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 output does not track the source afterwards; a quick rerun brings it up to date.
- Any known limits?
- No special preconditions.
Works well with
- Before you start, consider Extract Email
- Afterwards, try Extract URL
- A good companion is 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.