View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RISXRAY RISXRAY is offline
external usenet poster
 
Posts: 4
Default Removing part of a number in Excel

I'm trying to make a 9 digit number a 5 digit number by removing the first
four numbers. I have several lines of data and would like to do this in one
or two steps.

Example: 123456789 to end up looking like 56789