My question seems like it would be quite common, but I can't find the answer anywhere:
So, if I have a list of names on Excel (that's over 200 people long), and the full name is all in one cell, and I want to separate the names (like you do with "text to column"), BUT the glitch is that some of the names are 3 words long and some are 2 words long. If I use the space as a delimiter, then the second column will be all messed up--because it will show a mix of both last and middle names together!
I need like an 'advanced' delimiter option--to specify that I only want to separate the LAST space--so that only the LAST names appear in the second column.
I ran into the same problem as well when I was separating addresses by column: For example:
Address #1: Orlando FL
Address #2: Ft. Lauderdale FL
You can't delimit with a space, or else it cuts address #2 off after "Ft.".
Seems like a common enough problem--but I can't find any answers to it.