How to Break Apart Upper & Lower Case Text with Power Query

Struggling with messy text like “JOHNsMiTH” in Excel or Power Query? Stop doing it manually. In this quick tutorial, I’ll show you how to split text into upper and lower case parts using custom Power Query logic—fast, clean, and way easier than you think.

This trick is a lifesaver for parsing names, cleaning form inputs, standardizing messy CSV imports, and polishing reports. Once you learn it, you’ll use it everywhere.

✅ What you’ll learn in this video:

How to split text into upper/lower case pieces in Power Query

Why this trick works for name parsing & data cleaning

A simple method you can use again and again—no coding required

If you work with data, this one’s going to save you hours.

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

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 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