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..
Recent Posts
- How to link files and change the file
- Reflecting on 2022 – Failures & Disappointments, what went well and lessons learned.
- How to check for duplicates across worksheets – using Power Query Append
- How to use removed unwanted spaces with Power Query – AKA Trim
- What I learned from the 2022 Tour de France