- In short
- Takes the last N characters of each cell into a new column to the right. Leading zeros and codes are preserved as text. 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
Take Right is used to take the rightmost N characters of each cell.
When to use it
It earns its place whenever you have to split a code's suffix off the end.
Example scenarios
- Split a code's suffix off the end.
What it needs
A single 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 Split menu in the Extract group and choose Take Right.
- 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
Take Right 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 does the result go?
- A new column.
- What happens to invalid or unexpected values?
- Text-safe.
- How are blank cells handled?
- Short strings handled.
- 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 Take Left
- As a next step, 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.