Thread
:
Sorting Numbers w/Aplha Suffix
View Single Post
#
1
Posted to microsoft.public.excel.misc
Moonray80
Posts: n/a
Sorting Numbers w/Aplha Suffix
Is there any way to properly sort a series of numbers with an alpha suffix?
Example:
92001
92001A
92001B
91005
I've tried to convert the numbers to text but the alpha suffix nubers still
end up in a separate group.
Reply With Quote