How to auto delete the first X digits in a cell number ?
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:)
|