sorting a column with numbers and text
 

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

sorting a column with numbers and text
 

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

sorting a column with numbers and text
 

How do you want them sorted? (as in by what part of the cell?) "Ford35"
wrote:

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

sorting a column with numbers and text
 

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

sorting a column with numbers and text
 

in sequential order. ist by numbers, second by text, and third by trailing
number ie; 1.5-1-mbvf-oo2, should be followed by 2-2-mdv-004, if these were
the only two tag numbers i was trying to sort!
--
Ford35


"tim m" wrote:

How do you want them sorted? (as in by what part of the cell?) "Ford35"
wrote:

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

sorting a column with numbers and text
 

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