View Single Post
Old 08-24-2013, 08:50 PM   #8
bronco0608
Ring of Famer
 
New to the Forum

Join Date: Jul 2007
Posts: 1,276

Adopt-a-Bronco:
None
Default

Quote:
Originally Posted by Br0nc0Buster View Post
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.
bronco0608 is offline   Reply With Quote