Forum Discussion
Tool for removing unwanted/obstructive/redundant characters
I've lately come across numerous questions on how to remove redundant/unwanted leading and trailing spaces. Question: Does the latest and greatest Excel 365 offer a ready-to-use and robust tool tha...
Use TEXT.TRIM for most space cleanup in Excel 365.
Task | Best Function |
Extra spaces (all kinds) | |
Non-printable characters | |
Non-breaking spaces from HTML | SUBSTITUTE(..., CHAR(160), " ") |
Combine all | TRIM(CLEAN(...)) or TEXT.TRIM(...) |
My answers are voluntary and without guarantee!
Hope this will help you.
That actually was never a problem for me. Always had ASAPUtilites Addin doing the work without a fuss. I hope you must have come across the same. ASAPUtilites > Text > Advance Character Removal or Replace
Hello,
thanks for your reply.No, I am not going to install third-party utilities.
Looking for a built-in tool with user-friendly interface.
