Hi,

Try

=YEAR(LEFT(A5,5))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Craig" wrote:

Hi,

I have one column of text imported into excel that looks like column A
data...I want to use a function that would give me whats in Column B, that
is, the year of the last two characters in col A...I tried the year function
and it worked for 1996-2000, but not for years 2001-2008...it gave me 2009 as
a result.

Any help appreciated very much

Craig
col A I want Col B to look like this:
01-00 2000
01-00 2000
01-00 2000
01-03 2003
01-01 2001
01-02 2002
01-07 2007
01-04 2004
01-08 2008
01-99 1999
01-98 1998
01-97 1997
01-96 1996