Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

How to remove blank spaces with Power Query

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!

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

2 Replies