Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SORT A LIST OF NUMBERS AND LETTERS A,B,C,D AND FIND MAX | Excel Worksheet Functions | |||
sort a range of numbers ignoring preceding letters | Excel Discussion (Misc queries) | |||
finding out the combination of letters! | Excel Worksheet Functions | |||
Sort mixed numbers/letters | Excel Discussion (Misc queries) | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) |