SUBSTITUTE

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 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 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