View Single Post
Old 08-24-2013, 08:29 PM   #7
Br0nc0Buster
2013 AFC Champs
 
Br0nc0Buster's Avatar
 
Shabby, not too

Join Date: Apr 2007
Location: Kansas
Posts: 5,503
Default

Text to columns the cells for staffing agency 2, and choose delimited
pick comma to break the data into two separate cells

Do the same thing for staffing agency three except using spaces instead of commas

That will break all the data into cells for their last name and cells for their first name
Use a concatenate formula to add those values into one cell to get "complete name"
Br0nc0Buster is online now   Reply With Quote