Power Query: Replace Letters in a String (Step-by-Step!)

In this walkthrough video, I'll guide you through a powerful #PowerQuery solution that helps to replace consonants in a string with the immediately preceding vowel. 👉 I show you how to create seemingly complex formulas step-by-step within the formula bar. The secret to this solution is that you can compare and select letters just like numbers! 😯 👉 By using List.Max or List.Min you can select letters from a list independently of the order in the list!

Follow along as I break down the process and make it easy to understand. Watch now and master the art of transforming strings with Power Query!

Here is the link to the Excel BI challenge itself: lnkd.in/eHxBcYcg

#Excel #PowerBI
Like 👍, comment 💬, and share ➦ with fellow data enthusiasts to spread the knowledge!


Ready to become a Power Query master? Join me, Matthias Friedmann, and learn advanced data techniques and solve complex Power Query challenges with ease:
🔔 Subscribe for more expert Power Query tutorials:    / @matthiasfriedmann  
Connect with me on LinkedIn for more insights, updates and tips: www.linkedin.com/in/matthiasfriedmann