Is there a way to sort digits within a cell?

Posted by Iszi on Super User See other posts from Super User or by Iszi
Published on 2012-07-06T06:16:03Z Indexed on 2012/07/08 15:18 UTC
Read the original article Hit count: 272

I'd like to know if there's an Excel Function, or a formula, that can be used to sort digits within a cell.

For example, if the value of A1 is 6193254807 and B1 has our formula with parameters set to sort ascending then B1 should equal 0123456789 (leading zero included). Of course, if the parameters were set so that it would sort descending then B1 should equal 9876543210.

Is there a way to do this, without wandering into VBScript, or macros, or something similarly exotic?

© Super User or respective owner

Related posts about microsoft-excel

Related posts about excel-2010