- In short
- Removes repeated items inside each cell (split by a delimiter) and writes the unique list into a new column to the right. A new column. The source table is left as it is; Undo Last brings it back if needed. The whole operation happens locally; nothing is sent anywhere.
What it is for
Remove Duplicates in Cell is used to remove duplicate tokens within a single cell.
When to use it
Most useful when you need to de-dupe delimited lists like 'A;B;A;C' inside a cell.
Example scenarios
- De-dupe delimited lists like 'A;B;A;C' inside a cell.
What it needs
A single column and an options dialog (split/join/case/order/trim/header). Supported data types: text, number, date (by selection).
How to use it
- Select the range to convert.
- Run Remove Duplicates in Cell from the Text & Numbers group on the XLMind Data tab.
- Tune the choices in the dialog before confirming.
- Confirm; a new column.
What it produces
A new column.
Effect on your data and undo
Remove Duplicates in Cell does not change your source data; the result is added as a separate item. One click on Undo Last brings everything back.
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 does the result go?
- A new column.
- What happens to invalid or unexpected values?
- Text-safe.
- 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 Add Prefix / Suffix
- As a next step, use Text to Numbers
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.