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

https://youtu.be/WNdqlCMsroE

Struggling with messy text like “JOHNsMiTH” in Excel or Power Query? In this quick tutorial, learn how to split text into uppercase and lowercase parts using custom Power Query logic—fast, clean, and easy. Perfect for cleaning names, form inputs, and messy CSV imports.

This method saves time and improves data accuracy for Excel users and data analysts. Boost your data cleaning skills and get professional results with this simple trick!