| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| sum column containing both text and numbers | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Hybrid Mode
