A normal Excel sort seems to me your criteria...

.75-2-mbv-167
.75-2-mbv-168
1.5-1-mbfv-001
1.5-1-mbfv-002
2-2-mdv-004

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Ford35"
wrote in message
they should first be sorted by numbers, than text in alphabetical order and
last by the trailing digits in the propersequence ie;.75-2-mbv-167,
..75-2-mbv-168
--
Ford35


"Jim Cone" wrote:
And how should they be sorted?...
by the last three digits, the numbers after the first dash, omitting the dots or ?
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html




"Ford35"
wrote in message
I am trying to sort a column with numbers and text eg;
..75-2-mbv-167
..75-2-mbv-168
2-2-mdv-004
1.5-1-mbfv-002
1.5-1-mbfv-001
these are identification tag's for valves.
I have over 2700 items with differnent code numbers!
I need help !
--
Ford35