View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] alwaysdallas1212@gmail.com is offline
external usenet poster
 
Posts: 1
Default Sorting Numbers with letter suffixes

On Monday, February 25, 2008 at 4:09:52 PM UTC-6, Terry Bennett wrote:
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?

Thanks.

I am in need of help exactly like this, but none of the answers so far are working for me. I have racecar #'s that I need to sort by, example 1, 1A, 2, 3, 4, 4V, 7, 8, 9, 9D, 10, 20, 30, 40, 40H, 42, 45, 45b, 60, 70, 80, 123, 132, 132A, 132C, etc. Is this possible in Google Sheets? Or is my only option to do it manually??

Stacy