ladies and gentlemen i have a challenge for you all. i wish to sort
cattle details using excel. i download the details from the department
of agriculture as follows;
UK 9 12345 678 6
UK 9 12345 679 7
UK 9 12345 680 1
UK 9 12345 681 2
where the "UK 9" is constant,
the "12345" is the herd number of animals-which i do not wish to sort,
the "678" is the individual animal's number, which i wish the animals
to be sorted in order of,
and the "1"-"7" is a "check number", every animal has the random number
1-7 at the end of their number.
As you can see, there are spaces between each different bit of
information.

you may think that this is easy, but what makes it more complicated
is;
the herd number, (e.g. 12345) is not necessarily 5 digits long, it can
range from about 4 to 8 digits, also in my herd of cattle there is a
wide variety of herd numbers, therefore not all 5 digits herd numbers
are the same.

to make matters more complicated, there are also animals in my herd
which are in a slightly different format;
314159-180-N
314159-181-O
314159-182-P
314159-183-Q
where there is no "UK 9"
the "314159" is the herd number of animals-which i do not wish to
sort,
the "180" is the individual animals number, which i wish the animals to
be sorted in order of,
and the "A-Z" is a "check letter", every animals has the random letter
"A-Z" at the end of their number.
As you can see, there are "-" between each different bit of
information.

if you would be able to tell me how to sort the animals numbers i would
greatly appriciate it.
if i cannot arrange both formats of data in order of animals number at
the same time, but can arrange each format of data in order of animals
number individually, i would still greatly appriciate it!

Thanks a million
Gerard


--
Gerard
------------------------------------------------------------------------
Gerard's Profile: http://www.excelforum.com/member.php...o&userid=28087
View this thread: http://www.excelforum.com/showthread...hreadid=475926