Originally Posted by Br0nc0Buster
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"
Thanks for the reply, bud. I really, really appreciate it.
These staffing agencies are all over the place with the name formats. I was just looking at the latest invoice, and one of them decided to middle initials and full middle names in there!
John Q. Wilson
Melissa Marie Owens
Terry C. Edwards
Michael O. Kim
This is hurting my head.