hi,
you can remove the frirst 4 characters with the following formula...
=MID(A1,5,10)
copy the formula and paste as values

regards
FSt1

" wrote:


Hi there,

I have the following in Cell A1 to A3.

ABC50293.01
ABC10006
ABC1000003

I want to automatically delete the first 4 digits in each cell, so
that it will become:

0293.01
0006
000003

How can i do that?

Thanks a lot.

cheers:)