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"