Change text in Power Query is easy to do. Some transformations include change the case (i.e., upper vs. lower), adding or removing spaces and changing special characters. All this can be done with in the Ribbon tools to the text in the cells. However if you wanted to change all the headers cells to make the text change case or remove characters, that would involved going into the M code. It’s not hard, but it’s worth it if you have a lot of column headers to change.

SUBSCRIBE to my channel https://goo.gl/wN3c3p

Excel Training https://www.exceltraining101.com/p/training.html

Excel Books & Tech Gear https://www.amazon.com/shop/dough

️ Tools: Screencasting https://techsmith.z6rjha.net/5Qe53

️ Tools: Microsoft Office https://microsoft.msafflnk.net/rKL0G

️ Tools: TubeBuddy https://www.tubebuddy.com/et101

This description may contain affiliate links and we’ll receive a small commission if a purchased is made using the links (but at no additional cost to you). It’ll support the channel and so more videos like this can be made. Thanks for your support!

If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: /”Convert Table in a PDF File to Excel/”
https://www.youtube.com/watch?v=COUOvhbQ4CQ
-~-~~-~~~-~~-~-

Please take the opportunity to connect and share this video with your friends and family if you find it useful.