View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
dena320 dena320 is offline
external usenet poster
 
Posts: 2
Default Sorting numbers with text

Hello,

I need to sort two colums - one is a date - example
3/20/2008
04/5/2008
5/07/2008
and then another column of numbers - example
2007A2563
2007B3546
2007A2873
I really need the numbers after the letter to be in order. The first
numbers just pertain to the year, the numbers after the letter are file
numbers.

Thanks for any help.
--
Dena320