replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER

  • Thread starter Thread starter Walter
  • Start date Start date
W

Walter

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.
 
This formula will strip it out
=RIGHT(G17,LEN(G17)-FIND("-",G17))
or you can use data>text to columns>
 
If you can't get rid of it at the source you can break it out once in Excel.

Try Data>Text to Columns>Delimited by>Other......enter a hyphen>Next

Select the first column and "Do not Import(skip)" and Finish.


Gord Dibben MS Excel MVP
 
Wow ... terrific advice ... many thanks!!
Gord Dibben said:
If you can't get rid of it at the source you can break it out once in Excel.

Try Data>Text to Columns>Delimited by>Other......enter a hyphen>Next

Select the first column and "Do not Import(skip)" and Finish.


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top