Hello, I'm having problem with names in a column A for example
I need to break up the name into last name - column A and first name in column B
Smith John
Jones Brown Randy
I need the Name in 2 columns
column A - Smith column B - John
column A - Jones Brown column B - Randy
So the logic is if 3 names strings in column A the first 2 strings = Last name and the last name string = first name
if on 2 name strings in column A then only first and last name (this I can do) but it's the 3 name strings in 1 column that is the problem.
Thanks for any suggestion or where to point me to an example
Bookmarks