Sort Text ascending / descending from a cell

Hi eddiedhs. Welcome to the forum.

I would be surprised if this can be done without VBA.

Try this user defined function by tigeravatar. If you are not familiar with how to install VBA code see the instructions following this code.

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Then try array entering this formula in B1. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

Change SMALL to LARGE to reverse the order.

Originally Posted by eddiedhs

Hi FlameRetired ,

Thanks for this, but i cannot get it work
Attachment 547551

Your attached has the strings in proper case. The original example was in upper case. Try array entering this.

Formula:

Please Login or Register  to view this content.