CHAR(10) Linefeed / CHAR(13) CarriageReturn Displays Square
Dave, the CLEAN formula will strip the carriage-return and stop the text from splitting over lines when the cells allows for wrap text. Normally CHAR(10) Linefeed is used rather than ......