Hi Pecoflyer, thanks for the reply. Your answer was as expected and i did try this method but didn't get my answer i will have to try again. However, in my search i was offerred this rather long formula solution which works a treat so i would like to share this with the community.



=MID(SUBSTITUTE(SUBSTITUTE(E1,"/","",1),"/","",1),FIND("/",SUBSTITUTE(SUBSTITUTE(E1,"/","",1),"/","",1))+1,FIND("/",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E1,"/","",1),"/","",1),"/","",1))-FIND("/",SUBSTITUTE(SUBSTITUTE(E1,"/","",1),"/","",1)))

Thanks for the help.

Oh!! where is the thanks button