sort an array

Are you still using Excel 2010?

That's what the OP said in the opening post.

I'm optimistic that most anything is possible with time, effort and ingenuity. Here's how I would probably approach this:

1) something like what you show (a;b;c;d) is not any kind of array in a spreadsheet, it is a text string. The first thing I would do would be to split that so that each value is in its own cell. A text to columns command (with ";" as the delimiter) will quickly and easily divide this text string into separate values.
2) Then a simple sort command will easily sort the values left->right.
3) Then a simple concatenation formula will rejoin the values into a text string like you started with. =A1&";"&B1&";"&...

Of course, some of this becomes more complicated if you are not allowed to use the text to columns or the sort commands. If something like this won't work because you must use formulas rather than these commands to perform the task, then let us know. You might also check your profile, because it says you are still using Excel 2010, and Excel version could be important so we know what formulas are available to you (or if you are even required to use Excel at all for this -- I think this would be easier in google sheets if you are required to use formulas but not necessarily required to use Excel).

One way:

Please Login or Register  to view this content.

How to install your new code
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
[B][I]


Then:
=CellSort(A3)

If you have upgraded to O365, then this will also work:

=TEXTJOIN(";",TRUE,AGGREGATE(15,6,MID(SUBSTITUTE(";"&A4,";",REPT(" ",100)),100*(SEQUENCE(LEN(A4)-LEN(SUBSTITUTE(A4,";",""))+1)),100)+0,SEQUENCE(LEN(A4)-LEN(SUBSTITUTE(A4,";",""))+1)))

OK - please update your forum profile.

Whom are you addressing?

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

If you have the latest version of Excel including the LET function, try

Formula:

Please Login or Register  to view this content.

If you're willing to use some VBA,

Please Login or Register  to view this content.

Then use this along with the SORT function in formulas like

Formula:

Please Login or Register  to view this content.

With all of the different options being offered, I guess I will offer one, too. Only mine only works in Google Sheets, but I think it is easier to understand what it is doing:

1) A split() function to convert the text string to a horizontal array split(A1,";") [Excel does not support a split function, as far as I know].
2) transpose() to transpose to a vertical array transpose(split(...))
3) sort() to sort the vertical array sort(transpose(...),1,true)
4) textjoin() to convert the resulting vertical array to a semicolon delimited text string. =textjoin(";",false,sort(...))

It probably doesn't change anything, since it only works in Google Sheets, but it muddies the waters with yet another choice for the OP.