Sorting in Excel 1

[jvet4]

I have data in excel in the following format:

abc-123-1012
abc-123-1013
abc-123-117
abc-123-1174
abc-123-123
abc-123-124

I am trying to determine a way to put these values in numberic order based on the number after the second hyphen (i.e. 1012, 1013, 117, 1174.....)

Any help would be appreciated.

Thanks,
Jason

 

[SkipVought]

hi,
you could parse the data into two columns (Data/Text to Columns) and sort on the second column. Skip,
metzgsk@voughtaircraft.com

 

[DaleWatson123321]

Jason, Skip and I often manage to offer more than one option...

Here's another... based on the advantage of having "resident" formulas - which would eliminate the need to parse the data.

In an adjacent column, use the following formula, which will permit you to sort numerically...

=VALUE(MID(A5,9,999))

Hope this is a useful alternative. Please advise.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[SkipVought]

Dale,
I like your alternative. It does not disturb the original data. Skip,
metzgsk@voughtaircraft.com

 

[jvet4]

Thanks for the Help, the formula worked perfectly!!!