you’ve got the option to use CLEAN to strip non-printing characters and strip line breaks from text.

Text without these characters is returned unchanged.

Note that CLEANwillremove line breaks if found.

Excel formula: Remove leading and trailing spaces from text

CLEAN will not remove extra space characters.

To remove extra space, use theTRIM function.

Unicode contains other non-printable characters that are not removed.

Excel formula: Remove line breaks

Seethis pagefor more information.

Excel formula: Remove unwanted characters

Article image

Excel TRIM function