Thanks to both of you for the quick response!

Jerry, your answer was particularly helpful thank you!!

Although this does work well, I am trying to avoid manually sifting through partially matched data and correcting mistakes.

There must be some formula / algorythim that allows for this (similar to Google search ie. Tyger Wodes will bring up Tiger Woods automatically)...

Maybe even some VBA or C++ integrated code will work??

Every problem has a solution and we shall find it!!

Until then...