Tag
Excel
Catch Errors With The IFERROR Function In Excel
IFERROR replaces a formula's error with anything you choose, which is what keeps a dashboard readable. It also swallows the errors that mean you made a mistake, so…
September 8, 2026 · Excel Formulas
Round Numbers With The ROUND Function In Excel
ROUND changes the value a cell stores, where number formatting only changes what that cell shows. Its decimal argument also accepts a minus sign, which rounds to the…
September 8, 2026 · Excel Formulas
Format A Number As Text With The TEXT Function In Excel
TEXT turns a number or a date into the formatted string you actually want to read, using the same codes as the Custom number format box. The catch…
September 7, 2026 · Excel Formulas
Replace Text With The SUBSTITUTE Function In Excel
Swap one piece of text for another without losing what was there before. It is case-sensitive where Find and Replace is not, and a fourth argument targets a…
September 7, 2026 · Excel Formulas
Count Characters With The LEN Function In Excel
Check import data before it breaks something downstream: a postcode that should be six characters, a reference that should be ten. Number formatting has no say in the…
September 6, 2026 · Excel Formulas
Remove Extra Spaces With The TRIM Function In Excel
Leading, trailing and repeated spaces all go in one formula. The non-breaking space a browser delivers does not, which is why some pasted text still refuses to match…
September 6, 2026 · Excel Formulas
Join A Range With A Separator With The TEXTJOIN Function In Excel
Set the separator once rather than repeating it between every pair. The ignore_empty flag is what decides whether a gap in your column shows up as a doubled…
September 5, 2026 · Excel Formulas
Join Text With The CONCAT Function In Excel
CONCAT glues cells together in one formula. The catch is that the range form runs your words together with no separator, and a joined date arrives as a…
September 5, 2026 · Excel Formulas
Generate A Grid With The SEQUENCE Function In Excel
Dragging the corner produces numbers that sit there. SEQUENCE produces numbers that recalculate: a whole grid from four arguments, sized from the data with ROWS so the numbering…
August 29, 2026 · Excel Formulas