Sorting Column Values (Ascending Year)

Hi,

I have values in Column A ( row 5 onwards) in the form of YY_ABCD eg. 02_0030

The YY part shows the year and the part after the underscore "_" is a number.

I want to arrange this data in ascending year form. I have data here starting from the year 1950 to 2010 (50_XXXX to 10_XXXX). So after sorting the column should start from 50_XXXX to 10_XXXX ( including the year 2000 i.e. 00_XXXX).

Can anyone show me how to do this in Excel or through a macro ?

Thank You,
JN

If you don't mind adding another column you could construct the year to be sorted on by the function

Please Login or Register  to view this content.

in, say C5, copying it down the column, and sort on column C. Note that the value 20 is used to separate the centuries. You could use any value that is appropriate to your data.

Sorry about that. I needed to use the value function to convert the string to a number. try this

Please Login or Register  to view this content.