need help for excel formula

[Jesan]

Hi,

Thanks in advance. Is there a way to get this result? First, I need the beginning year and last year combine. Then, after it I need the years trim to only the last 2 digits.

2008	2008-2014	08-14
2009
2010
2011
2012
2013
2014

 

[Peter_SSs]

Try in B1

=A1&-MAX(A:A)

In C1

=MID(B1,3,3)&RIGHT(B1,2)