Need Help with excel

Joined
Sep 1, 2005
Messages
4
Reaction score
0
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!
 
Back
Top