Hi,

How can I sort the values within each cell in a column ?

So not sorting the column but sorting every value in each cell alphabetically ?

Thanks

Nikolaas

Hi,

How can I sort the values within each cell in a column ?

So not sorting the column but sorting every value in each cell alphabetically ?

Thanks

Nikolaas

Can you please provide an example?

Hi

Here is an example. So each value in colA is sorted alphabetically to form colA_sorted. So it is not a column sort but a sort inside each cell.

I expected that EasyMorph would have a sort() function that we could use in expressions with the option to choose the sort order (ascending, descending).

Yes thatâ€™s a good workaround. However it would be better if it is in a function

I have the same needâ€¦but in my case itâ€™s a cell that has numbers separated by commas.

So for example a cell has value of 20,1, 12. How could I sort this to be 1,12,20? I tried the above solution, but it treats each character as something to be sortedâ€¦

You can use the â€śSplit delimited values into rowsâ€ť action, sort, and then concatenate back. Here is an example:

sort-inside-cell.morph (3.4 KB)

2 Likes

Ahh thanks @dgudkov - I forgot about the split delimited values into rows function. Your solution worked flawlessly as usual!

Youâ€™re welcome

To learn more about EasyMorph visit easymorph.com.