Sort within a number (Excel 2003)

Topic

New Reply

I’ve been asked by a colleague how to sort data that is a number but they want to sort by the eighth and ninth number in a 10-digit number. Is there some way to do this? See attached word doc with sample numbers. Thanks….Carol

Reply | Quote

Replies

It would have made more sense to attach an Excel workbook.

Are the values in the Excel workbook numeric values that have been formatted to display leading zeros, or are they text values?

Reply | Quote

I didn’t get the spreadsheet but they are text.

Reply | Quote

Your colleague should be able to use the formulas from column B or C in the example I posted in my previous reply. If the data are sorted on this column, the column with the ten-digit numbers will be sorted with it.

Reply | Quote

Thank you….that works.

Reply | Quote

Here’s a sample workbook that demonstrates a possible approach, using an extra column to extract the 8th and 9th digits.

Reply | Quote