View Single Post
  #10   Report Post  
Old April 24th 18, 04:36 PM posted to microsoft.public.excel.worksheet.functions
[email protected] is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2018
Posts: 1
Default Sorting Numbers with letter suffixes

On Wednesday, February 27, 2008 at 4:42:44 AM UTC-5, Terry Bennett wrote:
Thanks again guys for the suggestions - much appreciated.


"Terry Bennett" wrote in message
Is there a way I can sort numbers such that if I have a letter suffix (ie;
2A, 3B, etc), they are sorted after the original number, ie; 2A between 2
and 3 then 3B between 3 and 4?


Change the data type to Plain text instead of Auto. Then when you sort it does it correctly.