removing characters/extracting names

**Figboot** · 04-15-2010, 01:14 AM

I have a long list (examples are attached). I need to extract just the person's name and have it in a format that I can then use for a VLOOKUP...so it can't have any extra characters and the like.

So, "Service Partner: Troy Sambrano" would have just "Troy Sambrano" in column A...but I'm looking for a formula that I can drag down and will work for all the varriations listed.

Suggestions?

**contaminated** · 04-15-2010, 02:36 AM

Maybe this formulae would help you

=RIGHT(B2,LEN(B2)-SEARCH(":",B2)-1)

**DonkeyOte** · 04-15-2010, 02:55 AM

Another variation thereof:

C2: =REPLACE(B2,1,FIND(":",B2&":")+1,"")
double click the black cross that appears in the bottom right of the cell to use Auto Fill on remaining cells