Forum Discussion
Sort fractions within a cell in Excel
I am trying to sort data within a cell (not a column/row) ...and it's in fractions. As an example, I have this in one cell: 1/2;1-1/8;22-12/18;1/8;1/22; I want it reorder the data in th...
Alternative for O365:
=LET(
ζ, TEXTSPLIT(A1, ";", , 1),
γ, ISERR(FIND("-", ζ)),
ξ, 0 + IF(γ, "0 " & ζ, SUBSTITUTE(ζ, "-", " ")),
TEXTJOIN(";", , SORTBY(ζ, ξ))
)
Not sure my system understand the special characters.