| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sorting dilema
I'm trying to sort a worksheet by part numbers. The problem is some part
numbers have a letter at the end, such as 'U' for unstamped, and those sort totally separate from the orginal part number. Any way around this? Here's an example to clarify. Part #s sort this way 000004 000110 304114 000004R 000110U 304114U I'd like them to sort 000004 000004R 000110 000110U 304114 304114U The cells are Text format so the leading zeros are displayed. Thanks in advance Bobbie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Sorting protected worksheet | Excel Discussion (Misc queries) | |||
| sorting detail rows - summary row in an outline | Excel Discussion (Misc queries) | |||
| Sorting problem | Excel Discussion (Misc queries) | |||
| sorting question | Excel Discussion (Misc queries) | |||
Threaded Mode
