IcarusHallsorts
Technical User
I have a column of names which sometimes contain just first and surnames, and sometimes one or more middle names, each separated by a space.
I want to split this into just two columns, one containing First and Middle (if present) Names, and the other the surname.
For example
Jean Luc Picard -> Jean Luc | Picard
Fred Bloggs -> Fred | Bloggs
May Jane Claire Smith -> Mary Jane Claire | Smith
where text before the | is the first new column, and anything after is the second new one
How can I achieve this using either a formula or VBA?
Any guidance appreciated.
I want to split this into just two columns, one containing First and Middle (if present) Names, and the other the surname.
For example
Jean Luc Picard -> Jean Luc | Picard
Fred Bloggs -> Fred | Bloggs
May Jane Claire Smith -> Mary Jane Claire | Smith
where text before the | is the first new column, and anything after is the second new one
How can I achieve this using either a formula or VBA?
Any guidance appreciated.