Thread
:
Sort combination of letters and numbers
View Single Post
#
1
Posted to microsoft.public.excel.newusers
Millabird
external usenet poster
Posts: 1
Sort combination of letters and numbers
I have this type of data to sort: C-1, C-2, C-3, C-4, C-5, C-6, all the way
up to C-500, but it doesn't sort into number order. How can I make it sort
by number, and disregard the "C-" part? thanks!
Reply With Quote
Millabird
View Public Profile
Find all posts by Millabird