Thread: Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Challenged Challenged is offline
external usenet poster
  
Posts: 6
Default Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort
Have a database and need to subtotal by a column that has no set number of
characters, some with "-" and a letter after, some just whole numbers. I
want to sort by the whole number and ignore the "-". Ideas?
Reply With QuoteReply With Quote