On Jun 2, 9:04*pm, Ron Rosenfeld wrote:
On Mon, 2 Jun 2008 12:42:31 -0700 (PDT), "

wrote:
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

If all of your desired data begins after R/, then:

=SUBSTITUTE(MID(A1,3,255),"/"," ")

If all of your desired data begins after the first "/", and there can be more
than one character before it, then:

=SUBSTITUTE(MID(A1,FIND("/",A1)+1,255),"/"," ")

--ron

Thanks this worked a treat and will save me a lot of time at work

Martin