View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
teetee209 teetee209 is offline
external usenet poster
 
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?
--
teetee