With your extracted value in A1

Try this:
B1: =MID(SUBSTITUTE(A1,"/"," "),3,255)

Is that something you can work with?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel

" wrote in message
...
I have a spreadsheet which imports data in the form R/IVE/0458 I need
to extract data to read IVE 0458 an added complication being that some
times there are 5 digits ie R/IVE/40755 which needs to read IVE 40755

Hope this makes sense, thanks in anticipation

Martin