- In short
- Extracts the text found between a start marker and an end marker into a new column to the right. Original values are never changed. A new column. Your table stays untouched, and Undo Last stands by if you change your mind. Everything runs on your computer, with no internet involved.
What it is for
Extract Between is used to take the text between a start and end marker into a new column.
When to use it
It earns its place whenever you have to extract a value between brackets/tags.
Example scenarios
- Extract a value between brackets/tags.
What it needs
A single column and an options dialog (start/end/trim/header); empty markers refused. 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 Split menu in the Extract group and choose Extract Between.
- Tune the choices in the dialog before confirming.
- Confirm; a new column.
What it produces
A new column.
Effect on your data and undo
Extract Between 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
Compared with a hand-built formula setup there is nothing to maintain; the source table keeps its formulas and formats untouched.
Good to know
No special preconditions.
Limitations
No special preconditions.
Frequently asked questions
- Where does the result go?
- A new column.
- What happens to invalid or unexpected values?
- Text-safe.
- How are blank cells handled?
- No-match handled.
- 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
- To tidy the data first, use Before / After
- 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.