Why does ‘H₂O’ become ‘H2O’ the second you hit Enter? Why does Alt+H, F, N do nothing when you’re trying to raise that ‘2’? Why does formatting work fine in Word but vanish in Excel after a cell edit?
The answer is simple: Excel treats text as either plain or formatted—but only after you tell it to lock formatting in place. Not before. And most people never give it that chance.
The Setup
You’re updating a product spec sheet for Acme Corp’s lab equipment line. Marketing sent you raw notes with chemical names, molecular weights, and reaction equations—all typed in plain text. Your job: clean them up for the engineering team’s internal dashboard (range A1:C9).
| Product ID | Chemical Name | Molecular Formula |
|---|---|---|
| CHEM-781 | Sodium Hydroxide | NaOH |
| CHEM-782 | Sulfuric Acid | H2SO4 |
| CHEM-783 | Calcium Carbonate | CaCO3 |
| CHEM-784 | Nitric Acid | HNO3 |
| CHEM-785 | Phosphoric Acid | H3PO4 |
| CHEM-786 | Hydrogen Peroxide | H2O2 |
| CHEM-787 | Ammonium Nitrate | NH4NO3 |
| CHEM-788 | Potassium Permanganate | KMnO4 |
The Challenge
You need to convert all numbers in column C—like the ‘2’ in H2SO4 or the ‘4’ in KMnO4—to superscript. But here’s what trips people up: if you double-click a cell, highlight just the ‘2’, and click the Superscript button on the Home tab… it works. Until you press Enter. Or until you sort the data. Or until someone else opens the file on a Mac. Then it resets.
The root cause? Excel doesn’t store character-level formatting unless the cell is in edit mode when you apply it—and even then, it only sticks if the cell stays as text (not formula-driven) and isn’t overwritten by another action. Worse: if you paste from Word or use AutoCorrect, Excel strips it silently.
Walking Through It
We’ll fix CHEM-782 (H2SO4) first—the most common case. Then scale it.
Step 1: Double-click cell C2 (H2SO4) to enter edit mode. Don’t just click once—that puts you in selection mode, not editing.
Step 2: Drag to select only the ‘2’. Hold Ctrl + 1 (that’s Ctrl+1—not Alt+1). The Format Cells dialog appears instantly. (Trust me, I learned this the hard way: Alt+H, F, N opens Font, but it doesn’t let you select *part* of the text unless you’re already editing.)
Step 3: In the Font tab, check Superscript, then click OK. You’ll see the ‘2’ lift up slightly. Now—here’s the counterintuitive part—don’t press Enter yet. Press F2 again to re-enter edit mode. Then press Enter. Yes, really. That forces Excel to commit the formatting as part of the cell’s text state.
Before:
| C2 = H2SO4 |
After:
| C2 = H2SO4 |
Wait—we added subscript too? Yes. Because real-world formulas need both. To get the ‘4’ as subscript: while still in edit mode on C2, highlight just the ‘4’, press Ctrl+1, choose Subscript, click OK, then F2 → Enter again.
Now apply the same to the rest—but skip manual dragging. Use Find & Replace with wildcards:
- Press Ctrl+H
- In ‘Find what’: type
H([0-9])SO([0-9])(enable ‘Use wildcards’) - In ‘Replace with’: type
H^&SO^&— then manually format each captured digit using Ctrl+1
That’s faster than doing all nine by hand—but only if you’ve done one manually first to understand the rhythm.
The Result
Here’s how your cleaned table looks—ready for export or printing:
| Product ID | Chemical Name | Molecular Formula |
|---|---|---|
| CHEM-781 | Sodium Hydroxide | NaOH |
| CHEM-782 | Sulfuric Acid | H2SO4 |
| CHEM-783 | Calcium Carbonate | CaCO3 |
| CHEM-784 | Nitric Acid | HNO3 |
| CHEM-785 | Phosphoric Acid | H3PO4 |
| CHEM-786 | Hydrogen Peroxide | H2O2 |
| CHEM-787 | Ammonium Nitrate | NH4NO3 |
| CHEM-788 | Potassium Permanganate | KMnO4 |
What Could Go Wrong
Three things break superscript more often than you’d think:
| Symptom | Cause | Fix |
|---|---|---|
| Superscript vanishes after sorting | Cell was formatted while NOT in edit mode—Excel stored formatting as ‘applied to whole cell’, not per-character | Always double-click to edit, then highlight & format. Never use Home > Font group on a selected cell. |
| ‘2’ appears tiny but not raised | You used font size reduction instead of Superscript checkbox in Format Cells | Ctrl+1 → Font tab → check Superscript (not just shrink font size). Size reduction ≠ superscript. |
| Formula cells show ‘#VALUE!’ after adding superscript | You tried to apply superscript inside a CONCATENATE or TEXT function—Excel doesn’t support rich text in formulas | Convert formula cell to static text first (copy → Paste Values), then format. |
One last thing: if you’re building templates others will use, avoid embedding superscript in headers like ‘Revenue (USD2)’. It breaks pivot tables and Power Query. Reserve it for static labels only.
Your next step: Open your current workbook, go to cell A1, and try this right now: type ‘x2’, double-click to edit, highlight the ‘2’, press Ctrl+1, check Superscript, click OK, then press F2 → Enter. Done. That’s all you need to know to start.
