Help with multiple Substitute formulas, I think??

So I have a column with names (last, first, middle init.). In this column there are 18 names that when they occur, I want to be able to add the word Contractor to their first name in parenthesis. The SUBSTITUTE method works flawlessly BUT it only allows me to use 7 instnaces in one formula. How can I accomplish this for 18 different names. I have the 18 names the way I want them (last, first (contractor)) in another column and have tried VLOOKUP but can't get it to work. Thanks for anyones help with this!!

Chris

If you have a list of those names say in X1:X18, then you can do something like:

=A2&IF(Isnumber(Match(A2,$X$1:$X$18,0))," (contractor)","") copied down

assuming the column of names to parse are starting in A2...

You can you post an example workbook?

Name Sheet.jpg

Here is a pic of part of the worksheet. The far right column is the list of the 18 names that when they appear in column D, need to read like they do in column E. Thanks!

You can you post an example workbook with this information and a before/ after example. Pictures are not really helpful.

Have you considered the formula I gave you above?

NBVC, works perfectly, thanks!!!