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