View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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