how to sort a string contains list of number in google sheet?

I have this string value in google sheet - in cell A1 : "10,6,9,5" , what is the formula to sort the value of A1 to get this result -> "5,6,9,10" ?

I tried to use this formula :

=TEXTJOIN(",", TRUE, SORT(VALUE(SPLIT(A1, ","))))

but it's not working.

Solution

You may try:

=join(",",sort(tocol(split(A1,","))))

How to stable-sort a flat array by each string's trailing integer
Custom sort the keys of a flat associative array
Google Apps Script sort stopped working "Exception: This operation is not supported on a table header row."
Alphabetically sorting strings
Sort the keys inside of each row of a 2d array
Recursive key sorting function is not affecting lower level items
(PHP) specific array sort
Sort a multi-dim array by a column
Sort a multi-dimensional array by a column
Sort all rows of a 2d array to align with the sorted result of a specific row
Sort a row of a 2d array and apply the same movements to all other rows
Sort a 2d array by three columns
Sort a 2d array by a column of d-n-Y formatted dates
Sort a 2-D array by a column
Sort an associative array by Y-m-d formatted keys
Array sorted by PHP gets unsorted when accessed in a Javascript for() loop
Sorting an associative array with `arsort()` prints 1 instead of the sorted array
How to sort a 2-d array by a column?
How to sort multi-dimensional array by a column and preserve the non-numeric first level keys
Sort an associative array by key in a descending direction
Sort a 2d array by one of its columns
Creating new String with sorted letters from a String word in Java
How to do a topological sort in PowerShell
Sorting ListView Groups?
Sort a map with "MMMyyyy" as key
How can I sort a vector of floats in Rust?
Weird pattern of hybrid radix+quick sort
Operation Order for Simultaneous Max/Min Search
How do I sort strings alphabetically while accounting for value when a string is numeric?
Stable sort an array of pipe-delimited strings only by the leading value