• Sorting Numbers with letter suffixes

    From obrien.music@gmail.com@21:1/5 to All on Sat Feb 8 08:28:43 2020
    Thank God for yo...@yogipatel.com providing the actual solution...

    Everyone above is annoying.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From alwaysdallas1212@gmail.com@21:1/5 to Terry Bennett on Thu Jul 9 07:25:11 2020
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)