View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JAC JAC is offline
external usenet poster
 
Posts: 15
Default Excel Question....Deleting Numbers In a Set

I have a set of numbers, ex: 43441900 However, I only want to keep the 4
numbers in the middle (4419). How do I delete the 1st set of numbers (43)
and the last set of numbers (00)? I need to copy this format in over 1000
rows.

I need help quickly. I have to present a report to my boss as soon as
possible.

Version...Excel 2003
Thanks