CLEAN

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