Home » Forums » Open Source Learning Center » Question and Answer

Sorting a mix of Hundreds, Thousands mixed in with text

Submitted by joeldm on 5 February, 2010 - 13:35

 

 I have inherited a list of products with names like these:

1117_Pit_Bull_Blue_Pointy.jpg

106-A-gymnast-child-girl.jpg

109Bgolfchildgirl.jpg

 

I am trying to sort these in Excel with no luck. The thousands end up mixed-in with the hundreds. I've tried changing the column to "numbers" but it doesn't appear to change anything. Is there a way to get Excel to recognize these leading numbers AS NUMBERS and sort them ascending and have the thousands end up AFTER 999?

Thanks!

JoeL
Atlanta, GA

 

AttachmentSize
sorting-problem.xls32 KB
‹ Linking Pages in a workbook. Image Reference ? ›
»
Nick's picture

sorting problem

Submitted by Nick on 5 February, 2010 - 17:10.

Here u go Joel.. I have written a VBA function to resolve this for u:

sorting-problem.xls

  1. Copy ur data over to this sheet
  2. copy the function down
  3. sort by what's returned in the function
»