replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER

[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.

 

[Don Guillett]

This formula will strip it out
=RIGHT(G17,LEN(G17)-FIND("-",G17))
or you can use data>text to columns>

 

[Gord Dibben]

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

 

[Walter]

Wow ... terrific advice ... many thanks!!

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