Ya thats just a few more than i'd like to create.

How about something like this =IF(ISERR(FIND("1",A1)),"","Miranda ")&IF(ISERR(FIND("2",A1)),"","Verificaiton ")....all they way thru your 8? Then you just have to decide how to seperate them if there are multiple values. I put a space at the end of the defect.