Several ways, here's a couple:
Probably the easiest:
Insert a column to the right of the current column and use Text to Columns
under Data, with the fixed column width option, to separate the entry into
two columns. The first containing just the first four characters and the
second everything else.
Or:
Use this formula in another cell to give you the data starting with the 5th
character:
=MID(H2,5,LEN(H2)-4)

" 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:)