Sort values in ascending order

[bjnockle]

Would like to use formula to sort a single value/letter in ascending order.

For example, A G A A A K K H H H should be A A A A G H H H K K

Thanks

[Crisp Packet]

Assuming that the data is in A1:A10. In B1 and copy down the following CSE formula. That is to commit the formula use the CTRL + SHIFT + ENTER.

Please Login or Register  to view this content.

[sandy666]

maybe DATA > Sort > Option > Sort Left to Right? (with case sensitive or not)

[bjnockle]

Solution works like a charm, Crisp Packet. Thanks

[sandy666]

thanks, bjnockle