=MID(A1,3,3)&" "&RIGHT(A1,4)
--
David Biddulph

"Martin B" wrote in message ...
Thanks for the quick reponse but if possible I'd like a space between the 3 letters and the 4 digits ie RVI 0444, not RVI0444. This is because I use the result as a look up value in a database which has spaces and also as a direct print out for production who are familier a 3 letter customer code and seperate 4 digit number.
Sorry for not being more specific in my original post

Martin
"David Biddulph" <groups [at] biddulph.org.uk wrote in message ...
If it's always the same number of characters in each part, then =MID(A1,3,3)&RIGHT(A1,4)
--
David Biddulph

"Martin B" wrote in message ...
Hi
I regularly import data from another program with part numbers identified in coloum A as:
R/RVI/0444
R/RVI/5362
R/VOL/3699 etc.

Is there a way of interogating the full part number and displaying only the middle three letters and the last digits with out the / between

Thanks in anticipation

Martin