Chapter headings, legal sections, Super Bowl editions, and copyright years all use Roman numerals. Writing them manually for large numbers like MMXXVI is slow and error-prone. Excel’s ROMAN function converts any integer from 1 to 3999 into its Roman numeral equivalent instantly. It also offers five notation levels — from strict classical (CDXCIX) to simplified (ID) — and pairs with the ARABIC function to convert back for calculations. This guide covers 8 practical examples including chapter labels, self-updating copyright years, lowercase preface numbering, sequential outlines with ROW, event edition labels, and everything you need to know about the form argument.

Excel has no built-in English function that converts numbers to words — but it does have BAHTTEXT (Thai only) and the Microsoft-published Spell Number VBA macro (English, any currency). This guide covers both fully. You will find all BAHTTEXT examples for Thai invoices, the complete Spell Number VBA code with plain-English annotations, step-by-step installation instructions, examples for cheques and payment vouchers, how to customize Spell Number for pounds, euros, or rupees, and a full comparison of every available method — including the GOOGLETRANSLATE workaround in Google Sheets and LAMBDA-based alternatives in Excel 365.

Concatenating a number with text in Excel instantly strips its formatting — the dollar sign, commas, and decimal places all disappear. The DOLLAR function solves this by converting a number directly to a formatted currency text string, preserving the symbol and precision in the output. It also rounds to any number of decimal places, including negative values that round to the nearest ten, hundred, or thousand — useful for executive summaries. This guide covers 8 practical examples: standard formatting, zero decimals, rounding to thousands, embedding currency in concatenated labels, dynamic precision from a control cell, conditional labels with IF, non-USD currencies with TEXT, and self-updating dashboard KPI strings.

Invisible characters break formulas silently. You import data from a database or web scrape, everything looks fine — until VLOOKUP returns #N/A on values that are clearly present, and COUNTIF counts zero for strings that visibly match. The culprit is almost always non-printable characters hiding inside the cells. Excel’s CLEAN function removes them in one step, stripping ASCII codes 0 through 31 that TRIM cannot touch. This guide covers 8 practical examples: basic cleaning, the standard TRIM+CLEAN pipeline, fixing non-breaking spaces with SUBSTITUTE, removing line breaks without merging words, diagnosing dirty data with CODE and LEN, and the master four-layer cleanup formula that handles every common invisible garbage type in a single formula.