From the example below, how can I write a formula so that I can extract just the name and have it read: Evan Dorris. I'm able to get Dorris with a left/find formula but can't get the first name - more so, I would need it First, Last name. All of the data sets I am working with have this same format so any help is appreciated....thanks!
"Dorris/Evan T-Ticket Related Serv"
Are all names in a "Lastname/Firstname" format?
You can use a MID/FIND to get the first name.
So...
=TRIM(MID(C1,FIND("/",C1)+1,FIND(" ",C1)-FIND("/",C1)))
Assuming there is a SPACE after the first name name
Last edited by Speshul; 09-11-2014 at 09:51 AM.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Awesome - huge help. Thank you!
Or just use one formula to get the name
=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND(" ",A1)),"/",REPT(" ",255)),255))&" "&LEFT(A1,FIND("/",A1)-1)
Dorris/Evan T-Ticket Related Serv Evan Dorris
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Many thanks - extremely helpful. As I'm working through the data, I actually see that instead of a space after Dorris/Evan, there are instances where it might be Dorris/Evan-
Is there a way to include in the same formula something to differentiate whether or not there is a " " or "-" after Dorris/Evan to produce the same result?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks