Remove all unwanted spaces in Excel
In this video, we will see how to Remove All Unwanted Spaces by using a very simple formula
This method also allows you to remove whitespaces, non-printable characters as well as Non-breaking spaces (CHAR160).
The formulae used are as below:
= TRIM("CELL REFERENCE")
= TRIM(CLEAN("CELL REFERENCE"))
= TRIM(CLEAN(SUBSTITUTE("CELL REFERENCE",CHAR(160)," ")))
Click here to subscribe to my channel to get more videos of Excel formula tips and uses:
/ @exceltipsvideos
Check out our Excel Graph Playlist for ideas on creating great-looking charts :
• Excel Graphs