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