Rearranging a String in Alphabetic Order

Problem:

The cells in column A contain 3-letter strings.
We want to rearrange each string so that its characters are sorted in alphabetic order.

Solution:

Use the CHAR, SMALL, CODE, and MID functions as shown in the following formula:
=CHAR(SMALL(CODE(MID(A2,{1,2,3},1)),1))&CHAR(SMALL(CODE(MID(A2,{1,2,3},2)),2))&CHAR(SMALL(CODE(MID(A2,{1,2,3},3)),3))

mandar
September 14, 2019 at 3:15 pm

Excellent formula, very useful. What if the number of Strings in column are uncertain. Ex A1 = DFRES A2= ARF A3=2DRESDF ??

Reply ↓
Nicholas Coppa
November 23, 2018 at 6:59 pm

I'm now interested in (and am in the process of working it out) making it work for a string of indefinite length.

Reply ↓
Nicholas Coppa
November 23, 2018 at 6:58 pm

Thanks a lot for working this out

Reply ↓

Leave a Reply Cancel reply

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.