View Single Post
  #1   Report Post  
Old July 9th 08, 03:11 AM posted to microsoft.public.excel.misc
teetee209 teetee209 is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2008
Posts: 1
Default 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?