I have a single column with names formatted as JohnSmith and need to split them into first name, last name. I can't find examples of this formula.

---

Reply from Richard Rost:

That's a good one. You have to have SOME way to split the names. In this case, it looks like you'd have to rely on the second capital letter (as long as all of your data meets that requirement). You'd need to create a custom function to loop down the string, check each character, and if it's a capital then you know where to split. I don't have any lessons on this yet, and it's way too complex to get into here, but if you're in a bind you can submit your question via the TechHelp page.