Find/Replace

Originally Posted by josephteh

Try this formula=SUBSTITUTE(A1,"/","",1)

Or, if the OP's examples were not truly representative and the data could have more than two slashes in it...

=SUBSTITUTE(A1,"/","")&"/"