Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting alpha numeric data
I have a very large data base (9,000 +) with a column of numbers such as:
K-8345-08; B-8346-08; O-8347-08. Is it possible to sort this data by number only and ignore the letter and hyphen? Can this be done with out adding a secondary column? -- teetee |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting alpha numeric data
I think you'll need the helper column.
teetee209 wrote: I have a very large data base (9,000 +) with a column of numbers such as: K-8345-08; B-8346-08; O-8347-08. Is it possible to sort this data by number only and ignore the letter and hyphen? Can this be done with out adding a secondary column? -- teetee -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting numeric and alpha entries | Excel Discussion (Misc queries) | |||
Sorting Alpha-Numeric Values | Charts and Charting in Excel | |||
Sorting Alpha Numeric Part 2 | Excel Discussion (Misc queries) | |||
Sorting Alpha Numeric | Excel Discussion (Misc queries) | |||
Alpha-Numeric Sorting | Excel Discussion (Misc queries) |