View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff
 
Posts: n/a
Default how to limit amount of numbers in cells in excel

I am trying to limit the amount of numbers that are in a cell. For example I
have a cell that has this sort of number 1220H123456, and I only want to have
the last six digits in that cell so I can sort in a numerical order. I have
been deleting the first 5 digits manually, but that takes way too much time
when the list has over 3000 rows. Any help would be wonderful!!!

Jeff