Splitting Text at the Second Uppercase - Do I use Functions or Power Query?

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 change in letter case…
Excel gives us different options to perform the same task.
In this tutorial I show you how to split text at the Second Upper Case character.
I’ll be using 3 methods, I call them Hard, Easy and Effortless…
Along the way I’ll show you some very useful Excel tips and tricks

You can Download the exercise file and follow along by clicking on the link:



You can read the Article on my blogsite:
www.See-How.ca

To book a corporate Training visit our corporate site:
www.OfficeInstructor.ca

Which of the 3 methods you prefer? let me know in a comment here under.

Excel,Uppercase,CHAR ROW,REPLACE,IFERROR,MIN,FIND,LEFT,Power Query,Flash Fill,OfficeInstructor,Nabil Mourad,