Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have files with a bunch of cells with mixed number/text information. I
would like to sort by the number only. Each cell contains a 1-3 digit number, and 0-2 letters in some combination of prefix and suffix. For example, a list might be: 3 A100C A100D AB205 B4 53DE And I would like it sorted by the number only. Actually, I would like it sorted by the number, then the suffix, then the prefix, but the number is a big step in that direction... Thank you :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number sort in Excel | Excel Discussion (Misc queries) | |||
Sort by part of a number | New Users to Excel | |||
Sort by number not by letter (C1, A2, B3, D4) | Excel Discussion (Misc queries) | |||
sort by section number | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |