Hi There,

Need help in finding a formula to arrange text ascending and descending from each cell.

Eg: Cell A1 has "EDDIE" , results in cell B1 (ascending) should be"DDEEI" and results in cell C1 (descending ) should be "IEEDD"

Thanks