Simple if/then statement- add text conditionally to cells

[Gamermatt]

Hello,

I have a list of cells in column A. Each cell is formatted like this:
93-95
81-08
71-77
07-11

Basically, i need to complete these years. So, if the number starts with a 7, 8, or 9, it should add 19 before it. If it starts with a 0 or 1, it should add a 20 before it.

So, it should look like this:
1993-1995
1981-2008
1971-1977
2007-2011

What is a fast way of doing this? I don't want to have to go through and find and replace each number. Although, i could use the wildcard * and use find a replace, example: find- 8* replace- 198* (but that does not seem to work)

Thanks,

Matt

 

[Jonmo1]

Try

=YEAR("1/1/"&LEFT(A1,2))&"-"&YEAR("1/1/"&RIGHT(A1,2))

the cutoff year is 30

29 = 2029
30 = 1930

 

[Gamermatt]

Try

=YEAR(("1/1/"&LEFT(A1,2)))&"-"&YEAR(("1/1/"&RIGHT(A1,2)))

the cutoff year is 30

29 = 2029
30 = 1930

That works, thank you!