Sorting colums in Excel
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
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).
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks