Excel

Convert Text To A Number With The VALUE Function In Excel A column of figures that refuses to add up is usually text, not figures. VALUE turns numeric-looking text back into a real number, and this shows what makes… September 10, 2026 · Excel Formulas Capitalise Text With The PROPER Function In Excel PROPER title-cases a whole column of names in one pass, with UPPER and LOWER covering the simpler cases. It starts a new word after every non-letter, so mcdonald… September 9, 2026 · Excel Formulas Count Non-Empty Cells With The COUNTA Function In Excel COUNTA counts every cell that is not empty, where COUNT takes numbers alone. A formula returning an empty string still counts, so two cells that look equally blank… September 9, 2026 · Excel Formulas 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