A aaac Joined Sep 1, 2005 Messages 4 Reaction score 0 Sep 1, 2005 #1 I want to split a column with employees names, some of the names are separated by "," and some are separated by " ". How can I take the first name if they are separated by " " and the last name if they are separated by "," ?? PLease help!
I want to split a column with employees names, some of the names are separated by "," and some are separated by " ". How can I take the first name if they are separated by " " and the last name if they are separated by "," ?? PLease help!