Excel

Insert The Current Date With The TODAY Function In Excel TODAY takes no arguments and returns the current date. It is volatile, so a column meant as a record quietly rewrites itself every time the workbook opens. September 14, 2026 · Excel Formulas Check A Cell With The ISNUMBER Function In Excel Two cells can hold the same characters and behave completely differently. ISNUMBER, ISTEXT and ISBLANK are the tests that say which repair a broken column needs. September 14, 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 Remove Line Breaks With The CLEAN Function In Excel CLEAN strips the line breaks a pasted address brings with it. It cannot touch the non-breaking space, so a cell can come out unchanged and still refuse to… September 13, 2026 · Excel Formulas Count With A Condition Using The COUNTIF Function In Excel COUNTIF takes its condition as text, so the operator lives inside the quotes and a cell reference gets joined on. Get it wrong and you get zero, with… September 12, 2026 · Excel Formulas Average A Range With The AVERAGE Function In Excel AVERAGE decides your denominator for you. A blank cell leaves it alone while a zero joins the sum, so the same column can honestly produce two different answers. September 12, 2026 · Excel Formulas Cut Decimals With The TRUNC Function In Excel TRUNC removes the decimals instead of weighing them. It agrees with INT on every positive number and disagrees with it on every negative one, silently. September 11, 2026 · Excel Formulas Locate Text With The FIND Function In Excel FIND returns the position of one piece of text inside another, ready to hand to MID. It is case-sensitive, and missing text gives an error rather than a… September 11, 2026 · Excel Formulas Extract Part Of A Text With The MID Function In Excel MID cuts a piece out of the middle of a cell by position. It also returns a short answer without warning when the cell runs out, which is… September 10, 2026 · Excel Formulas