Excel Function

Excel has no dedicated tick-mark button, but it offers five distinct ways to insert one. The Symbol dialog works for one-off insertions with no setup. Alt+0252 in Wingdings is the fastest keyboard-only method. Shift+P in Wingdings 2 is even quicker once the column is pre-formatted. The CHAR function brings ticks inside formulas — combine it with IF to show a tick when a task is done and a cross when it isn’t. Unicode ✓ and ✔ paste directly into any font without changing a thing. This guide covers all five methods, then shows how to count ticks with COUNTIF, restrict a column to ticks and crosses only using data validation, and color entire rows green or red with conditional formatting

Excel has no built-in SPELLNUMBER function, but three methods fill the gap. The VBA NumToWords function is the most flexible — paste the code once into a module, save as .xlsm, and use =NumToWords(A1) anywhere in the workbook. The AmountToWords extension adds currency and sub-unit names, producing invoice-ready output like “One Thousand Two Hundred Fifty Dollars and Seventy-Five Cents” automatically. For macro-restricted environments, a LAMBDA function defined in the Name Manager achieves the same result with no VBA at all — fully compatible with .xlsx files. This guide covers all three methods with eight practical examples: basic conversion, multi-currency invoice lines (USD, GBP, AED, INR, EUR), cheque format with the XX/100 fraction convention, a dynamic currency table driven by XLOOKUP, and how to lock the output as static text before sharing a finalised document.

Learn when to use STDEV.S and STDEV.P in Excel. This tutorial blog covers Bessel’s correction, quality control, financial volatility, z-scores, rolling standard deviation, and 8 practical examples with formulas. Explore other tutorials to learn more about Excel Functions.

Master Excel’s PERCENTILE.INC, PERCENTILE.EXC, QUARTILE.INC, PERCENTRANK, and RANK.EQ functions. This tutorial blog covers eight practical examples covering performance banding, salary analysis, outlier detection, grading curves, and executive dashboards.

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.

Excel’s REPT function repeats any character a specified number of times — making it the simplest way to build in-cell bar charts, progress bars, and star ratings without chart objects or conditional formatting data bars. Unlike data bars, REPT output is plain text that recalculates faster, stays stable when copied, and can change color based on custom threshold rules via conditional formatting. This guide covers the syntax, the best Unicode characters to use, and 8 practical examples including scaled bar charts, filled-and-empty progress bars, star ratings, tally marks, and the classic “z×255” trick for finding the last text entry in a list.

CONCAT replaced CONCATENATE as Excel’s standard text-joining function — but many users still reach for the older name out of habit. This guide explains the four ways to concatenate in Excel, shows exactly when to use each one, and walks through 10 real-world examples covering full names, postal addresses, order codes, date labels, conditional suffixes, and comma-separated lists. Whether you’re joining two cells or an entire column, you’ll find the right formula here.

Learn how to use Excel’s INFO function to get the operating system, Excel version, calculation mode, open worksheet count, and default directory. Covers all 7 type_text values with practical examples.

Learn how to use Excel’s NUMBERVALUE function to convert text numbers to values with custom decimal and group separators. Essential for European formats, imports, and cross-locale workbooks.