Part No Sorting

  • Thread starter Thread starter Darrian
  • Start date Start date
D

Darrian

Hi
I have an interesting problem which is giving me some trouble sorting
I have a list of tube part no's I need to get information from:
TH260587207358
TH260666808080
TH260701008649
TH260873010475
TH260968311500
TH261047812319
TH260150602500
The information required is in the last 10 digits i.e. 0587207358 which is
58.72mm I/D and 73.58mm o/d. Is there a formula,argument to break down each
part no into its parts?

Mat i/d o/d
TH26 058.72 073.58

All help would be appriciated.

Darrian
 
Darrian,

You could just split it with

B1: =LEFT(A1,4)
C1: =MID(A1,5, 3)&"."&MID(A1,8,2)
D1: =MID(A1,10, 3)&"."&MID(A1,13,2)

etc

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top