Dear Sir,

Lets consider the following worksheet:

A B C D E
Original Extract Sequence
1 0424905001 424905 Y 424905
2 0424907001 424907 Y 424906
3 0424908001 424908 Y 424907
4 0424909001 424909 Y 424908
5 0424910001 424910 Y 424909
6 0424911001 424911 Y 424910
7 0424912001 424912 Y 424911
8 0424913001 424913 Y 424912
9 0424914001 424914 Y 424913


I used =MID(A1,2,6) to extract for the six digit reference number in column
B.