Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
You can right click on the column header and pick "Replace Values" and replace " " with nothing.
You can right click on the column header and pick "Replace Values" and replace " " with nothing.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |