We're nominated again this year for Best Microsoft Excel Add-in at the Global Excel Awards! ❤️🌟
If ASAP Utilities has helped you in Excel, you can support it with a quick vote→. It only takes about 30 seconds.
Find us in the second category: Best Microsoft Excel Add-in. You can skip other categories if you're unsure about them.
logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Sunday April 5th, 2026

Tip of the Day | Sunday April 5th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Subscript Numbers in Chemical Formulas

This tool applies subscript formatting to the numbers in chemical formulas in your selected text cells.
It automatically detects where the numbers should be subscripted based on standard chemical notation.
This includes element counts (e.g., H₂O), numbers inside parentheses (e.g., NO₃)₃, and hydrate notations using dots (e.g., · 4H₂O).
All other formatting in the cell remains unchanged. Cells that contain formulas, numbers, or dates are skipped.
Examples where numbers are formatted as subscript:
  • "H2O" becomes "H₂O" (Water)
  • "C8H10N4O2" becomes "C₈H₁₀N₄O₂" (Caffeine)
  • "C6H12O6" becomes "C₆H₁₂O₆" (Glucose)
  • "Al(OH)3" becomes "Al(OH)₃" (Aluminum hydroxide)
  • "Ca(NO3)2 · 4H2O" becomes "Ca(NO₃)₂ · 4H₂O" (Calcium nitrate tetrahydrate)
  • "NaHCO3" becomes "NaHCO₃" (Baking soda)

    Screenshots

    Example screenshot: Subscript the numbers in Chemical Formulas
    Subscript the numbers in Chemical Formulas

    Starting this tool


    Text  ›  Subscript Numbers in Chemical Formulas

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.