View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] dstdst123@excite.com is offline
external usenet poster
 
Posts: 5
Default 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:)