Sorting Column Problem

[cmf0106]

For the file attached I am trying to sort by year first, then quarter. How do I go about doing this.

For instance it currently reads
2Q05
1Q06
4Q05
3Q05

Which is obviously incorrect I need it to read

2Q05
3Q05
4Q05
1Q06

My current fix was adding a new column labeled year. And then doing a sort by year and then by quarter. Is there a way to get this to sort out correctly without adding that extra column?
Many thanks

[Palmetto]

If your value read as 051Q or 05Q1, then you could sort without the need for the extra column.

In another adjacent column you could change the order using this formula then copy and paste values into the quarter column
=RIGHT(A2,2)&LEFT(A2,2) = 061Q

or

=RIGHT(A2,2)&MID(A2,2,1)&LEFT(A2,1) = 06Q1

[shg]

Is there a way to get this to sort out correctly without adding that extra column?

Make sure that the year was derived from the quarter string, and not manually entered.

I'd put month and year in one column, and use a formula derive the quarter string from that:

=INT((MONTH(A1)+2) / 3) & "Q" & RIGHT(YEAR(A1), 2)