Remove ALL Unwanted Spaces in Excel

Stubborn spaces can become a headache in Excel. You'll come across extra spaces when you copy data from your email or import data from another system. Each cell value ends up having trailing or leading spaces. Sometimes they can be removed easily with the TRIM function but sometimes TRIM doesn't work! In this video I'll show you how you can TRIM ALL Spaces - also the stubborn ones.

TRIM can only remove spaces with an ASCII character code 32. But there is another character code that represents a space. It's commonly referred to as a Non-Breaking Space and its ASCII character code is 160. Such spaces commonly occur when we copy text from Outlook or a website to Excel. With the Excel function CODE() we can identify which character code we are dealing with.

To remove a non-breaking space in Excel we can use the SUBSTITUTE function. With this function we can look for character code 160 in a cell and replace it with a regular space.

For numbers that are not recognized as numbers by Excel we can use the VALUE function. If the number contains non-breaking spaces use it in combination with the SUBSTITUTE function.


This video solves below queries.
1. Remove all unwanted spaces in excel
======================================================
Also take a look at more videos
1. Excel Tips & Tricks Playlist
Link -    • List All Sheet Names From Excel File ...  
2. Power BI Dashboard Tips
Link -    • Dynamic Page Navigation in Power BI| ...  
3. Power BI DAX Trick and Tips Playlist
Link -    • Power Bi Contribution Analysis Using ...  


======================================================