Removing digits "2012" from cells that end with "2012"

[canadian86]

I have some numbers in Column A:

12322012
388292
37284984382012

I'm looking for a formula that removes the "2012" IF the number ends with "2012"

So from the above, I would get this result:

1232
388292
3728498438

Thanks.

 

[VoG]

Try

=IF(RIGHT(A1,4)="2012",LEFT(A1,LEN(A1)-4)+0,A1)

 

[Andrew Poulsom]

How about?

=LEFT(A1,LEN(A1)-(4*(RIGHT(A1,4)="2012")))

 

[canadian86]

Thanks guys.. works perfectly!