How to remove spaces in Power Query

Power Query Remove Excess Spaces

In a previous post, we looked at various methods to remove additional spaces in Excel. One of the methods involved creating a custom function in Power Query. As this is a more advanced method, I wanted to go a bit deeper and describe the method to remove spaces in Power Query. Table of Contents Excel … Read more

How to remove spaces in Excel (7 simple ways)

Remove spaces in Excel - Featured Image

The space character for an Excel user can be a real problem. When exporting data from various IT systems, that export will often include extra spaces around values. Finding a way to remove spaces in Excel is a crucial skill for every user. We often can’t see the space characters, but Excel sees them. They … Read more