Power Query

Splitting Text at the Second Uppercase letter… Functions, Power Query and More

If you have a string of text, like a full name without spaces, and you want to split it into 2 columns: one for the first name and another one for the last name, you look for a pattern, like the chang...

Create a Retirement Report using Functions, Advanced Filter, Dynamic Arrays or Power Query

Retirement Report using Functions, Dynamic Arrays and Power Query To get the best out of Excel, you need to combine the different functionalities together in achieving your goal. In this project, We h...