cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
o59393
Post Prodigy
Post 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:

 

llklklklklkl.JPG

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!

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

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

2020-06-06_18-19-33.png

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User
Super User

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

2020-06-06_18-19-33.png

@jdbuchanan71 thanks 🙂

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.