How to Remove Duplicates Within a Cell in Excel
Excel's Remove Duplicates works across rows, not inside one cell — so a cell like "a, b, a, c" keeps its repeats. Here's why there's no built-in for it, and the one-click way.
Last updated: August 2026
| Before | After | |
|---|---|---|
| a, b, a, c | → | a, b, c |
| red | blue | red | → | red | blue (pipe) |
Why there's no simple way
Excel's Remove Duplicates only compares whole rows, so it never looks inside a single cell. To dedupe within a cell you have to chain TEXTSPLIT, UNIQUE and TEXTJOIN — a combo that only runs on Microsoft 365 — or write a VBA macro and trust it. Both are far more effort than the job deserves, and neither is portable across Excel versions.
The 1-click way — Tellsheet's Dedupe Within Cell
Select the column and run Dedupe Within Cell. Choose the delimiter — comma, semicolon, pipe, space or newline — and it drops repeated items from every cell while keeping first-seen order, so "a, b, a, c" becomes "a, b, c". An optional trim tidies spaces so " b" and "b" aren't treated as different. No 365-only formula, no macro. Pairs with Remove Duplicates and Join Column into One Cell.
Frequently asked questions
Does Excel dedupe within one cell?
No — Remove Duplicates works across rows only. There's no built-in for within-cell dedupe, hence the 365-only combo or a macro.
Which delimiters are supported?
Comma, semicolon, pipe, space and newline. It splits, removes repeats, and rejoins with the same delimiter.
Does it keep the original order?
Yes — first-seen order is preserved, so only later duplicates are dropped and nothing is re-sorted.
Can it trim spaces around items?
Yes — an optional trim means " b" and "b" aren't treated as different items.
Related Excel guides
Dedupe within a cell in one click
Dedupe Within Cell strips repeated items from each delimited cell, keeping first-seen order — no 365-only formula, no macro.
Get Tellsheet free See pricing