Hi,

Put this in a helper column and drag down

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

Mike

"Wu" wrote:

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?