How to remove blank spaces with Power Query

[o59393]

Hi all

How can I remove the blank spaces using Power Query?

For example I have this column with these values:

So for example I would like to have:

FormulaOptimization

SupplyChainOptimization

WaterTreatment

The reason I want to have the values with no spaces is to create hashtags like seen on Twitter.

Thanks all!

[jdbuchanan71 · Accepted solution]

You can right click on the column header and pick "Replace Values" and replace " " with nothing.

[o59393]

@jdbuchanan71 thanks 🙂