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

Join Date: Apr 2007
Location: Kansas
Posts: 6,007

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 offline   Reply With Quote