How to Remove Extra Spaces using Power Query in Excel

[@anillpatel]

Fantastic Video Presentation.
This is exactly the Function I was looking for.
Thanks Ajay.

[@chaswa68]

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

[@medishettyvamshi5640]

Thank you Anand.

[@GosCee]

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

[@krishnakishoremalisetty3003]

This is brillient Ajay!! thanks for sharing.

[@ParsaH]

Very helpful! Works perfectly! Thank you very much!

[@damdelima]

Thanks man! Works like a charm!

[@paramjeet975singh3]

sir is this possible with trim function

[@AjayAnandXLnCAD]

You are absolutely right. But the Power Query method is more Dynamic than any other method. Please watch the video till end and let me know what you think.

[@paramjeet975singh3]

@@AjayAnandXLnCAD ok i will watch

[@peterpferdproductions1043]

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.

[@r_faelpereira]

Pretty good solution. Thanks for sharing

[@curious888-8]

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

[@mnowako]

Awesome! Thank you!

[@IMAS7512]

Dear how to remove spaces in number colomn

[@bijoomalloor1647]

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..?

[@kcomarcos]

replace " " for "" without the quotes would work

[@neto8733]

Amazing