Forum Discussion
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
=TEXTJOIN(", ",TRUE,SORT(FILTERXML("<y><z>"&SUBSTITUTE(A1,", ","</z><z>")&"</z></y>","//z")))
2 Replies
=TEXTJOIN(", ",TRUE,SORT(FILTERXML("<y><z>"&SUBSTITUTE(A1,", ","</z><z>")&"</z></y>","//z")))- Detlef_Lewin Thank you!
