Formula Remove slashes, insert X in front of first character and remove last to characters

I have text in Col A1 eg 2001/003285/96


I would like a formula to remove the slashes (/) , insert X in front of first Character and remove last to characters in B1

It should look like this X2001003285 once extracted


Your assistance is most appreciated

Please Login or Register  to view this content.

Thanks for the help guys. Formula works perfectly

=SUBSTITUTE("x"&TRIM(LEFT(SUBSTITUTE(A1,"/",REPT(" ",LEN(A1))),2*LEN(A1)))," ",)

Thanks for the help Ghozi

If your data always starts with 4 digits followed by a slash followed by 6 digits as your example seems to suggest, then you can use this simpler formula...

="X"&LEFT(A1,4)&MID(A1,6,6)

Thanks for your formula Rick. The data will always start with 4 digits followed by a slash followed by 6 digits