Formulas to sort text in cells.(Microsoft Excel)

01/21/2023

Japanese version.

Here are the formulas to sort within a single cell.

However, you will need Excel that reflects newer features such as Microsoft365.

Contents

Formula

The CONCAT, SORT, MAKEARRAY, LEN, LAMBDA, and MID functions are used in the formula.

Please make changes in the areas in red.

=CONCAT(SORT(MAKEARRAY(LEN(Text),1,LAMBDA(row,col,MID(Text,row,1))),,1))

The cell 2c5e31ad4b is reordered to 12345abcde.

Change the last 1 to -1 to sort in descending order.

The cell 2c5e31ad4b is reordered to edcba54321.

---