Excel Like TRIM Function in Power Query

Here in this video, we will talk about how you can remove unwanted spaces from your text values in Power Query. We'll also learn about creating dynamic custom functions.

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== CHAPTERS =====
0:00 Intro
0:21 Removing Spaces
4:28 Creating a Function
8:51 Applying to Multiple Columns
10:44 My Courses

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

[joelabacherli]

I’ve scrolled past this video for a while. Finally checked it out and I wish I would have earlier. This is incredibly helpful to format the messed up data I get every day. Thank you so much as always. You are awesome.

[MilhouseBS]

Thanks! Another super video. I've been doing Power Query since Data Explorer, and I'm still learning from your videos.

[Sumanth]

Very practical solution..Had this exact issue last month.. Replicating the function to all columns was genius :) learnt something new today..

[dianamgdata]

Never saw a function creation in Power Query before! I have to try it out in my reports!

[jameszhou]

You read my mind Chandeep! Was thinking about scalability of this custom function. This is perfectly ✅done. Thanks a million

[FsoOmar]

Thank you Chandeep, your channel is my no. 1 source for learning for free. I guess this video is a duplicate of another one labeled "Remove unwanted spaces"! But thank you again and again. 😊

[HachiAdachi]

I'm going to feel sMarter all day today because I spent 12 minutes watching this video this morning. Thank you, Chandeep! 🙏

[olegariocamara]

Dude, this video is THEEEE BEST, helped me with so many problems I was having today! GREAT WORK !!!

[adrianoschwenkberg]

A great and smart Solution using the given capabilities of M-Functions.

[nishantkumar]

Awesome 👌 You took care of scalability very well

[amitk]

The way you explain is amazing one can easily understand even complex things . Excel is fun, laila gharani and ur YouTube channel are very helpful, keep it up

[laurentmarc]

Really impressive ! Seems so easy, but for anybody it would require hours of work. Thx a lot for this nice tip

[gennarocimmino]

what to say?
simply brilliant.
Very useful functions and approaches explained in really simple language.
Thank you for sharing these tricks.
see you next time.

[syedaneesdurez]

Thank you very much for the amazing solution.

[SalihKocaSK]

Thanks for another very useful and helpful content @Chandeep. Would you think to include inseparable space (which is very common in copied text from browsers) and line break characters next time? It was my challenge last week, somehow I sorted it out but I am sure that you have simpler and more sophisticated solutions.

[luisjavier]

It is pretty awesome. I came across with your channel two days ago and I am really excited about all the thing that I have learned. Kudos

[williamarthur]

Thank you again for another interesting video, it was great that you went on to make a function,
which I still find tricky at times, especially if there are multiple columns to work on, not so bad if it works on a table.

[izzatkiswani]

after this brilliant content, the question why Microsoft make Trim function in PQ not as in excel

Thanks Chandeep !

[raimundojs]

Fantastic! I had no idea we could apply a function to all columns like that. Thank you a lot!

[AAAExcel]

Last trick is really amazing - thank you 🙏