tons of Thank you ,=MID(RIGHT(SUBSTITUTE(A1,"-","_"),100),FIND("_",RIGHT(SUBSTITUTE(A1,"-","_"),100))+1,100), it worked perfectly.