Remove Spaces From Column Names in All Tables Automatically in Power Query - EMT 1625

Learn how to use the Table.TransformColumnNames and Text.Trim Power Query M Code functions to automate removing spaces in field names for all the tables that are being imported.

[RobMichaels]

Thanks to Bill & Mike for another useful trick demonstrated! You might mention for those (unfortunate) people still using Excel 2016 that we don't have the ToolTips when we add a Custom column formula. (unless there is a setting somewhere I don't know about).

[ThermalWarrior]

Thanks Mike, you and the great Bill are Grand Masters of the Excel world!

[jimfitch]

Thanks, Mike ... & Bill ...
You’re right. The conversation on the video that led to this one was a lot of fun. I appreciate how you produced this follow-up so quickly. 👍

[mattschoular]

Thanks Mike and Bill S. Another great trick to save my insanity. Keep up the great work team....

[msantosh]

Thanks to you and Bill for this video. Excel is fun with Mike Girvin ❤❤❤

[Softwaretrain]

Wooow ... Smart and easy way to trim column name. Bill Szysz always has an awesome solution.
Thanks Mike, I was sure you would make this tutorial.
You and Bill made me full of energy.

[mailashish]

I was wondering how come Mike didnt turn with something which will take care of all spaces.
So there u r!!!
U r an inspiration Mike!!!

[sherryizzie]

Love it! I used to go back to the table to remove the space one by one. Now with this trick, it’s going to save me lots of troubles! Thanks, Mike!

[GeertDelmulle]

That’s a fine trick right there. Thanks Bill and Mike.

[vida]

That's a great short way. I used a longer one in past. When tables are expanded: 1. use header as first row, 2. Transpose (from tab 'Transform'), 3 Trim text in the headers column, 4. Transpose, 5. Use first row as headers. However, have you noticed, if headers contain few words and there are extra spaces between them, PQ would not eliminate these. PQ only removes extra spaces from beginning and end. Then I would capitalize each word and replace space with nothing

[ndjanardhan]

Thank u Sir and Bill Szysz Sir for Great Video. Its Really very Useful Tip for Time Saving for removing Extra Spaces in Columns Name. 😀😀😀👌👌👌.

[kiwikiow]

Thank you Mike and Bill for sharing your knowledge. Like ghost picture that disappeared after refresh, it's cute :)

[ogwalfrancis]

Thank you so much for that Awesome solution, Mr. Bill is really a great Power Query expert

[rrrprogram]

I Was little busy.... But i have some episodes to cover.... This one was good one mike.... Thanks for awesome vidoes

[enriquedominguez]

Thank you Mike and Bill. It is a great time saving trick.

[SyedMuzammilMahasanShahi]

Thanks Mike for this EXCELlent video. You are amazing.

[roywilson]

Thanks Mike, another excellent video. As always very informative and succinctly presented :)

[wayneedmondson]

Thanks Mike (and Bill) for another great trick! And.. you experienced the phantom ghost row that I mentioned in your other video. Glad to have an answer for that : ) As always.. many thanks for the super tips and tricks that you distribute day after day.. much appreciated and valued. Double thumbs up for ExcelIsFun!!

[sullyt]

Nicely done. However, it is worth considering that the data itself (not just the headings) may have unwanted spaces. Accordingly, I take a slightly different approach:
1. Demote Headers.
2. Trim all columns.
3. Promote Headers.
4. Change Type – to format columns accordingly.

[ismailismaili]

Thank u so so much Mr. Mike u are always the best