View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Walter Walter is offline
external usenet poster
 
Posts: 78
Default replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER

I am importing basketball stats from another site. No problem until I import
the Free Throws Made/Free Throws Attempted stats. Here each cell contains
two numbers separated by a dash ... for example: 17-24 indicating 17
successful free throws were made out of 24 attempts. Since future
computations involve using only the Free Throws Attempted number, I am
interested in importing only the second number. What process must I go
through to accomplish that? Obviously I am new to Excell and will be most
appreciative of any assistance you can give me.