Excel Formula help 1

[bamundsen]

Hello:

I have a column of year ranges like this:

Year
1999-1999
1990-1997
2005-2005

I would like to convert any year ranges that are identical such as 2005-2005 to 2005. Currently I run a Find/Replace, but I have year ranges all the way back to 1965. Is there any way to do this w/an excel formula.

Thanks,

Brett

 

[AnotherHiggins]

How 'bout this:
=if(left(a1,4) = mid(a1,6,4),left(a1,4),a1)

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[bamundsen]

Thank you very much anotherhiggins. This will save me alot of time.

 

[AnotherHiggins]

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[macropod]

Or, slightly simpler:
=if(left(a1,4) = right(a1,4),left(a1,4),a1)

Cheers