Aug 25 2021 09:54 AM
I need to sort numbers within a cell. 2018-09484, 2019-05944, 2016-03137 to 2016-03137, 2018-09484, 2019-05944
Aug 25 2021 10:02 AM
Solution=TEXTJOIN(", ",TRUE,SORT(FILTERXML("<y><z>"&SUBSTITUTE(A1,", ","</z><z>")&"</z></y>","//z")))
Aug 25 2021 10:14 AM
Aug 25 2021 10:02 AM
Solution=TEXTJOIN(", ",TRUE,SORT(FILTERXML("<y><z>"&SUBSTITUTE(A1,", ","</z><z>")&"</z></y>","//z")))