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



Posted by Aladin Akyurek on October 11, 2001 12:58 PM

Concat

Somkiat,

CONCATENATE cannot applied to constant arrays or to a range. I think this alone would stand frustrate your project if you're after a system of formulas that must do the task.

Aladin

=======