How to Remove Extra Spaces using Power Query in Excel

Thank you for this, Ajay. How could I remove extra spaces from a column in a nested table before expanding the table?

Dear how to remove spaces in number colomn

Thank you so much for publishing this. I managed to add a slight adjustment that helped me with my problem: to remove only multiple spaces and not single ones, the also to replace with a delimiter so I could then split the columns. It's not perfect but if anyone else needed this then here is that changed code. The delimiter is # in this case. I also put two spaces in the x function instead of one.
(text as text)=>
let
x = Text.Split(text," "),
y = List.Select(x,each _<>""),
z = Text.Combine(y,"#")
in
z

Very helpfull for me, thank you very much! I tried with search for two spaces or more and replace with nothing like in MS Word "SPACE{2;}", but this did not work.

Here it is the full trim code in case you want to use it ^^

(text as text)=>
let
x = Text.Split(text," "),
y = List.Select(x,each _<>""),
z = Text.Combine(y," ")
in
z

Thanks for the awesome video!

Thanks man! Works like a charm!

Very helpful! Works perfectly! Thank you very much!

Pretty good solution. Thanks for sharing

Awesome! Thank you!

This is brillient Ajay!! thanks for sharing.

It’s working with your method, awesome!! Thanks very much.

Amazing

Is there any short cut method for this instead of write program ..? Substitute funtion will remove all spaces including single space between words.. Trim will not remove space in between words.. So, is there any other function which will remove only extra spaces from a sentence..?

sir is this possible with trim function