Thread: How?-Sorting last digits and not the first
View Single Post
  #1   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
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.

Reply With QuoteReply With Quote