- In short
- Takes the text before or after a marker (first or last occurrence) 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
Before / After is used to take the text before/after a marker into a new column.
When to use it
Most useful when you need to split 'name surname' or 'code-description' at a marker.
Example scenarios
- Split 'name surname' or 'code-description' at a marker.
What it needs
A single column and an options dialog (marker/after/occurrence/trim/header); empty marker 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 Before / After.
- Pick the settings you need in the window that opens.
- Confirm; a new column.
What it produces
A new column.
Effect on your data and undo
Before / After 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-marker handled.
- Does the result stay linked to the source?
- What you get is static: it will not follow later edits, so rerun the tool once the data moves on.
- Any known limits?
- No special preconditions.
Works well with
- Before you start, consider Take Right
- Afterwards, try Extract Between
- 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.