View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jason Jason is offline
external usenet poster
 
Posts: 367
Default Delete numbers within cells

I have over 1800 rows of data that are sorted by ID number. The problem is
the column with the ID number has 2-3 extra numbers; Is there a way to delete
the extra numbers in each row? I've tried ASAP utilities to no avail. I'm new
to Excel so please keep that in mind when offering any much needed and
appreciated advice.