How to Standardize Inconsistent Values in Excel (Cluster & Clean)
One column, meant for one value, ends up with New York, new york, and NewYork all treated as different. Cluster the variants and unify each group to a single form in one pass.
Last updated: August 2026
| Messy value | Unified | |
|---|---|---|
| new york | → | New York (case) |
| NewYork (trailing space) | → | New York (spacing, word order) |
Why cleaning by hand doesn't scale
Excel has no clustering — nothing that says "these ten spellings are really one value." So the manual route is to eyeball the column, spot each variant, and Ctrl+H them to a common form one at a time. On a real dataset that means dozens of passes, and it's easy to miss the ones that differ only by an accent, a stray space, or reversed word order.
The 1-click way — Tellsheet's Standardize Values
Select the column and run Standardize Values. Tellsheet clusters spellings that differ only by case, punctuation, accents, or word order and unifies each cluster to one form — like OpenRefine's cluster & clean, but inside Excel and on your PC. The result is a consistent column ready for pivots, lookups, and deduping. Pairs with Clean Company Names and Fuzzy Match.
Frequently asked questions
What does clustering mean?
It groups values that are really the same but differ by case, punctuation, accents, or word order, so you can unify each group at once.
How is it different from Change Case?
Change Case only fixes capitalisation. This also clusters on punctuation, accents, and word order, then unifies the cluster.
Why not find-replace each variant?
Excel has no clustering, so by hand you'd find-replace every variant one at a time — slow and easy to miss. This surfaces the groups.
Does it change data in place?
Yes — it unifies each cluster to one form directly in the column, ready for pivots and lookups.
Related Excel guides
Unify a messy column in one pass
Standardize Values clusters spellings by case, punctuation, accents, and word order, then unifies each group — OpenRefine in Excel.
Get Tellsheet free See pricing