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 |
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 |
All times are GMT +1. The time now is 01:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com