On Wed, 4 Jan 2012 16:15:47 +1000, "Mal" wrote:

Ron,
I am sorting the names in Last Name / First Name order outside the text I
have sent to this forum so this should not be a problem.
My problem was with the "Mc Mahon" (with space) or McMahon (no space) both
the same person which I think I have now solved with the help of this group.
I just thought my solution may have been of interest to others in the group.
I realise it is not bulletproof with split names such as "van der vort" etc
potential problems but I can live with that.

Mal

OK, I was going to offer a VBA solution that would match things up as well as possible, but since you already have a working solution, I will put that off.