View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jrkaisersr@gmail.com is offline
external usenet poster
 
Posts: 3
Default How?-Sorting last digits and not the first

Thanks for the help all! It worked great :) I'm a satisfied
customer....

Jason

wrote:
I have the following data:

S12345
S12346
12347
12348

I would like to sort it in ascending numerical order, omitting the
leading 'S'. Is there anyway to do this?

Many Thanks,

Jason R. Kaiser Sr.