LinkBack URL
About LinkBacks
Unfortunately that was not a mistake. Some of the names don't have spaces.
Also I am sure there are names with two first names etc..but for the vast majority of them it is the standard "Last, First" format. I don't mind if it doesn't work for some.
Unfortunately that was not a mistake. Some of the names don't have spaces.
Also I am sure there are names with two first names etc..but for the vast majority of them it is the standard "Last, First" format. I don't mind if it doesn't work for some.
Solved part of my own problem hah. I trimmed the cells to remove all the redundant spaces then I used =SUBSTITUTE(L2,RIGHT(L2,8),"")
L2 being the cell with the issue. I used 8 because I noticed that they all had dates at the end with the 8 character format XX/XX/XX. Now I just need to pull the names. Any ideas?
Cells now look like
AllSource Smith, Peter
inSync Staffing, LLC Palmer, Robert
Flexible Staffing Jeffries, Victor
Last edited by smtwidle; 06-25-2012 at 02:13 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks