Sorting colums in Excel

[Camsti]

Hi there

I have a column which looks like this:

110
111
111b
112
113
114a
114b
115
Osv.

When I sort it, all the cells with 3 digits on top and all the cells containing 3 digits and a letter are in the bottom.
I looks like this:

110
111
112
113
115
111b
114a
114b

Is there a funktion in Excel which can sort the column correct?

Kind regards
Overgaard

[CK76]

Any text is considered greater than number in Excel. Hence, all string that has text will end up at bottom.

If you need to sort based on number and then on alphabet, you'd need helper columns or VBA.

Helper column method.

Add 2 columns, 1 for number part and another for text part (use formula etc to extract each).

Then use those 2 columns to sort.

See attached sample (Check sort ribbon tool in data tab).