replace the content of cell

[Wu]

I have the following data:

A01-2007

A-01-2006

I Would like to replace the right hand side 5 characters, like below result:

A01

A-01

How can I do this?

 

[Jim May]

=LEFT(A1,LEN(A1)-5)

 

[Mike H]

Hi,

Put this in a helper column and drag down

=LEFT(A1,LEN(A1)-5)

Mike

 

[Max]

This might suffice ..
In B1, copied down: =LEFT(A1,LEN(A1)-5)