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,

To whose post does this belong to? In case to my post #4, then the formula returns a string of any length, situated between code string, and 1st occurrence of any numeric character after the code string.

Sorry, but for next 2 weeks I can't see what you have in your example file - I'm on annual leave currently, and I don't have MS Office in my home computer.