Excel table: -1-1 to -1-1700 how to ascend

3 Answers

1. +4Votes  

   Upload sorting is to select the column (row) and click:

   You are not the ascending order that Excel says, it is the custom sequence that Excel said.

   Do you mean this:

   -1-1

   -1-2

   -1-3

   ……

   -1-1700

   If yes, solve it by adding auxiliary columns (rows).

   Marie- December 21, 2018 |

2. +8Votes  

   The cell format is set to

   "-1-"0

   to be in ascending order, Or sorted in descending order.

    

   Gregory Adams- December 21, 2018 |

3. +1Votes  

   You can’t directly sort by 1 to 1700 directly!

        Because your format is definitely text format, text sorting and number sorting are not the same

    

   To reach Sort by last number:

          You can only add one copy column, extract the last number to this auxiliary column, and sort by auxiliary column

   Figure effect:

   B1 input formula:

   =–RIGHT(A1,LEN(A1)-FIND("-1-",A1)-2)

   This can be sorted by column B auxiliary columns, as shown in descending order

   Johnson- December 21, 2018 |