» 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))