Selected Answer
HI
I have had a quick look at your problem. The trick is there does not appear to be any simple rule to Identify the code.(we won't call it a number)
In a number of cases you could take all the characters to the first blank space. You would needs some rules around th hyphen. and I have noticed that sometimes the hyphen has a space around it.
The next chanlenge is where the number is not first but appears somewhere in the text.
It is a job for artificail intaligence.
I would try using a macro and use the split command on the space then look at each element and choose the one which has at least 6 numbers. If you need the hyphen check the next element and concatenate if required.
I have added a function to your excel which does some stuff