Power Query (AKA Get and Tranform) is Excel’s amazing data cleansing tool. You can use it to remove unwanted spaces in your data but I have noticed that sometimes it doesn’t remove everything that you would expect. This video shows you a technique you can use when you find it doesn’t remove all the the spaces you expect. Here is the original file if you want to play along..
