Forum Discussion
o59393
6 years agoPost Prodigy
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
- jdbuchanan71Super User
You can right click on the column header and pick "Replace Values" and replace " " with nothing.
- o59393Post Prodigy
jdbuchanan71 thanks 🙂