Forum Discussion

ch2221655's avatar
ch2221655
Copper Contributor
Aug 25, 2021
Solved

How to sort numbers in a cell separated by a comma

I need to sort numbers within a cell. 2018-09484, 2019-05944, 2016-03137 to 2016-03137, 2018-09484, 2019-05944
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Aug 25, 2021

    ch2221655 

    =TEXTJOIN(", ",TRUE,SORT(FILTERXML("<y><z>"&SUBSTITUTE(A1,", ","</z><z>")&"</z></y>","//z")))
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Aug 25, 2021

ch2221655 

=TEXTJOIN(", ",TRUE,SORT(FILTERXML("<y><z>"&SUBSTITUTE(A1,", ","</z><z>")&"</z></y>","//z")))

Resources