Hi Pike,
Thanks for the help but i just get the name? error i have tried to reverse engineer the mid and find formula but to no avail. i am running excel on osx but have checked and all the functions (mid, find, substitute are usable on this version) do you have any clues? thanks again for the help!!!!