View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill Bill is offline
external usenet poster
 
Posts: 390
Default Removing unwanted digits

Hi,

i'm not sure how to explain this but here goes...

i have cells containing 12 digit numbers. I need to remove the first 3 and
the last 2 digits. As there are 1000 plus cells (all in the same colum) which
i need this to occur is there a way to automate this inexcel?

thanks,

Bill