Left / right...?

[How_Do_I]

Hi all,

I have years in the format below with the "-" between the two...

I need the formula to put 09 in Q6 and 10 in Q7 please... If I used 2006 - 2007 I'd need the 06 and 07 in the respective cells.

Excel Workbook
	Q
5	2009 - 2010
6	9
7	10
All Seasons

 

[baodinh]

In column J, convert the text in column I to value eg: formula in cell J19 =value(I19) then sort by column J.

 

[How_Do_I]

Thanks for that...

 

[Scott Huish]

You shouldn't need VALUE, just add 0:

=RIGHT(H19,2)+0