I have a name column in my spreadsheet that I want to separate into two columns,a firstname+middle column(Name1) and a lastname+title column (Name2) . Not all of the names in the current Name column are formatted the same (i.e. some people don't have middle initial or have 2 middle initials). Is...
I have a name column in my spreadsheet that I want to separate into two columns,(firstname+middle) and (lastname+title). Not all of the names are formatted the same (i.e. some people don't have middle initial or have 2 middle initials). Is there a way I can separate the names into two...