Forum Discussion
Solved
Name seperation
I'm trying to seperate names into two columns where some people have double first names and some don't. For example: Full Sarah Anne Smith John Smith Lilly Rose Plant Jane Austen I c...
Depending on if other people are going to be looking at it (usually why workplaces prohibit VBA), it's probably best to keep it simple.
Harun24HR's response is a great dynamic spill range solution, but if it's a collaborative sheet with less proficient users, you may want to reduce it to just a textbefore column, and a textafter column:
Threw in a hyphenated surname just to illustrate that won't impact anything. Both formulas are looking for the last instance of a space (-1), and extracting text before/after accordingly.
I used Flash Fill on you sample data and it worked 100%.