It’s 9:13 AM. You’re pasting a vendor list into a new sheet for procurement review. You type excell in cell A1 as a placeholder header—then realize, mid-sentence, that your teammate just slid into your Slack with: ‘Did you mean Excel? Because “excell” isn’t a thing.’ You freeze. Not because it’s wrong—but because you’ve done it 17 times this month.
The Setup
You’re auditing internal contact records from Q1. The raw data lives in a shared folder named Vendor_Contact_Raw.xlsx. It’s messy: inconsistent casing, trailing spaces, and yes—three entries where someone typed excell instead of Excel in the 'Software Used' column. No one flagged it. Until now.
| Company | Contact | Software Used | Last Updated |
|---|---|---|---|
| Acme Corp | Sarah Chen | Excel | 2024-03-15 |
| Nexus Labs | Miguel Torres | excell | 2024-02-28 |
| Vanta Systems | Jamie Okoro | EXCEL | 2024-04-02 |
| Blue Ridge Advisors | Tanya Patel | excell | 2024-01-19 |
| Orion Dynamics | Derek Wu | Microsoft Excel | 2024-03-22 |
| StellarEdge Inc | Lena Kim | excell | 2024-02-10 |
| Quill & Co | Rajiv Mehta | Excel | 2024-04-05 |
| Frostline Group | Aisha Diallo | EXCEL | 2024-03-30 |
| TerraLink Solutions | Kenji Tanaka | excel | 2024-02-05 |
| Veridian Analytics | Maya Ruiz | Google Sheets | 2024-04-01 |
The Challenge
You need to standardize the Software Used column (C2:C11) to read Excel—capitalized, single-word, no extra spaces, no typos. But here’s what makes it tricky:
- ‘excell’ appears in lowercase, uppercase, and mixed case—so
=SUBSTITUTE(C2,"excell","Excel")won’t catchEXCELLorExCell. - ‘Microsoft Excel’ and ‘Excel’ are both valid—but you must preserve the shorter form, not duplicate words.
- There’s no built-in spell-check for custom lists. Excel won’t flag excell unless it’s in your personal dictionary—and yours probably doesn’t include it.
And yes—it’s Excel, not Excell. The name comes from excellent, but Microsoft dropped the second L in 1985 to match the branding of Word and PowerPoint. It’s not a typo. It’s a trademark.
Walking Through It
We’ll fix this in four steps. Do them in order. Don’t skip Step 2—it’s the counterintuitive one.
| Step | Action | Result | Shortcut |
|---|---|---|---|
| 1 | In cell D2, enter: =TRIM(UPPER(C2)). Drag down to D11. | All entries become uppercase, spaces removed: EXCEL, EXCELL, MICROSOFT EXCEL, etc. | Ctrl+C, then Ctrl+V to paste values after step 3 |
| 2 | In E2, enter: =IF(ISNUMBER(SEARCH("EXCEL",D2)),"Excel",D2). Drag to E11. | This catches any variation containing "EXCEL"—including EXCELL and MICROSOFT EXCEL—and replaces the whole cell with Excel. | Alt+= to auto-sum (not used here—but good to know when you forget) |
| 3 | Select E2:E11 → Copy → right-click C2 → Paste Special → Values. | Column C now holds clean, standardized Excel entries—no formulas, no dependencies. | Alt+E+S+V (Paste Special → Values) |
| 4 | Delete columns D and E. You don’t need them anymore. | Only Column C remains—now consistent, professional, and audit-ready. | Ctrl+Space to select column, then Ctrl+- to delete |
Why Step 2 works: SEARCH is case-insensitive *inside* UPPER(), and ISNUMBER(SEARCH()) returns TRUE even if the substring appears in a longer string like MICROSOFT EXCEL. That’s why you don’t need separate logic for full vs partial matches.
The Result
Here’s what Column C looks like after all steps—clean, uniform, and correct:
| Company | Contact | Software Used | Last Updated |
|---|---|---|---|
| Acme Corp | Sarah Chen | Excel | 2024-03-15 |
| Nexus Labs | Miguel Torres | Excel | 2024-02-28 |
| Vanta Systems | Jamie Okoro | Excel | 2024-04-02 |
| Blue Ridge Advisors | Tanya Patel | Excel | 2024-01-19 |
| Orion Dynamics | Derek Wu | Excel | 2024-03-22 |
| StellarEdge Inc | Lena Kim | Excel | 2024-02-10 |
| Quill & Co | Rajiv Mehta | Excel | 2024-04-05 |
| Frostline Group | Aisha Diallo | Excel | 2024-03-30 |
| TerraLink Solutions | Kenji Tanaka | Excel | 2024-02-05 |
| Veridian Analytics | Maya Ruiz | Google Sheets | 2024-04-01 |
What Could Go Wrong
Three real mistakes people make—and how to spot them before hitting Save:
- Typing
=SUBSTITUTE(C2,"excell","Excel")without UPPER() first: It only fixes lowercase excell. LeavesEXCELL,ExCell, andexcell(with space) untouched. You’ll miss 60% of errors. - Pasting formulas instead of values back into Column C: Now every cell depends on Column E. If someone deletes E2:E11 later, Column C shows
#REF!. Always useAlt+E+S+V. - Running AutoCorrect to replace “excell” → “Excel” globally: Excel’s AutoCorrect will change excellence, excellent, and excelling to Excelence, Excel lent, Exceling. Yes—this has broken reports at two Fortune 500 clients this year.
Next step: Open your most-used workbook. Press Ctrl+H. In Find what, type excell. Click Find All. If results appear, run the 4-step process above. Do it now—not Monday.
