How to auto delete the first X digits in a cell number ?

D

dstdst123

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

FSt1

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
 
B

BoniM

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)
 
B

BoniM

Sorry about the h's, forgot to fix for yours...
=MID(A1,5,LEN(A1)-4)
You can enter it with a fixed length, =MID(A1,5,10) but letting excel check
for the length LEN(A1) minus the 4 characters at the beginning, means you'll
never accidently cut stuff off the end if a number ends up being longer than
you anticipated.
 
Top