EXACT

Convert Text To Capitals With The UPPER Function In Excel UPPER converts every letter in a cell to capitals. It is often used to compare cells without case, which the equals sign already does on its own. October 1, 2026 · Excel Formulas Compare Two Cells With The EXACT Function In Excel The equals sign ignores case, so a reconciliation built on it calls Smith and SMITH the same row. EXACT does not, and it is strict about trailing spaces… September 13, 2026 · Excel Formulas