Alphanumeric sorting

mathetesI have attached a sample of my spreadsheet as it is too large to attach more. I am trying to sort the numbers next to the dollar amounts while keeping the dollar amounts next to the numbers so columns E & F need to be sorted together I only want to sort from rows 6 through 16

mathetes Hi. You will have to interpret the part before the minus sign as numeric.

c4 =IFERROR(NUMBERVALUE(LEFT([@Data];FIND("-";[@Data])-1));[@Data])

FIND("-";[@Data])-1)

Find the minus and substract one to find the numnur of digits.

LEFT([@Data];FIND("-";[@Data])-1))

Get that number of characters

NUMBERVALUE(LEFT([@Data];FIND("-";[@Data])-1))

Turn it into a numeric value

IFERROR(NUMBERVALUE(LEFT([@Data];FIND("-";[@Data])-1));[@Data])

If there is no minus FIND will generate an error. If so, return the value as is

Column D and E are optional depending on your need.

d4 =IFERROR(NUMBERVALUE(RIGHT([@Data];LEN([@Data])-FIND("-";[@Data])));0)

e4 =[@[Num 1st]]-[@[Num 2nd]]

[@Data] means same row in pyamas tables field Data.
If using an ordinary range, replace [@Data] with B4.

Generally, I prefer using MID since it's one function that can be used also for left and right. In the attached file though, LEFT and RIGHT are used.