Thank you for looking into this matter for me. Your formula will work if the name is at the same length/ number of character but unfortunately they are not. I have attached a revised sheet with more information and hope you can help.

Many thanks,