How to Clean Company Names in Excel (Strip Inc, Ltd, LLC)
Acme Inc., ACME & Co, and Acme Ltd should be one company — but to Excel they're three, so deduping and lookups miss them. Normalise the names once so every variant lines up.
Last updated: August 2026
| Raw name | Canonical | |
|---|---|---|
| Acme Inc. | → | Acme (suffix stripped) |
| ACME & Co | → | Acme (&, case, suffix) |
Why manual cleaning misses cases
Manual Ctrl+H find-replace can't catch every legal suffix — Inc, Ltd, LLC, GmbH and dozens more — and the moment you standardise one, another slips through. Chained TRIM and SUBSTITUTE formulas fare no better: they miss the & vs and problem, leave stray punctuation, ignore casing, and grow into an unreadable nest before they cover half the variants.
The 1-click way — Tellsheet's Company Name Canonicalizer
Select the column and run Company Name Canonicalizer. Tellsheet strips legal suffixes (Inc, Ltd, LLC, GmbH…), standardises & and and, and tidies punctuation and casing so every variant collapses to one canonical form. It's the CRM and procurement clean step to run before deduping or matching, and it works entirely on your PC. Pairs with Standardize Values and Fuzzy Match.
Frequently asked questions
Which suffixes does it strip?
Common ones like Inc, Ltd, LLC, and GmbH, so Acme Inc. and plain Acme reduce to the same canonical name.
Does it handle & versus and?
Yes — it standardises them to one form and tidies punctuation, so ACME & Co and ACME and Co line up.
Better than TRIM and SUBSTITUTE?
Yes — those miss cases and grow unreadable. This applies the whole normalisation in one pass.
When should I run it?
As the clean step before deduping or fuzzy matching — canonical names make both far more accurate.
Related Excel guides
Make company names line up
Company Name Canonicalizer strips suffixes, standardises & vs and, and tidies punctuation — the clean step before deduping.
Get Tellsheet free See pricing