Sorting characters with array formula
Posted by Somkiat on October 10, 2001 6:43 PM
Word in A1: ZYX
Following formula creates an soting characters with array of {"X","Y","Z"}
{=TRANSPOSE(CHAR(SMALL(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),ROW(INDIRECT("1:"&LEN(A1))))))}
How to concatenate all orders in this array to be a word of XYZ ? I can not figure out the answer. Any other formulas to sort alphabet in each cell?
For example:
Hello ----> olleH
Somkiat -----> taikmoS
Done -----> enoD
Thanks,
Somkiat