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.

replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER
 

This formula will strip it out
=RIGHT(G17,LEN(G17)-FIND("-",G17))
or you can use datatext to columns
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Walter" wrote in message
...
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.

replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER
 

If you can't get rid of it at the source you can break it out once in Excel.

Try DataText to ColumnsDelimited byOther......enter a hyphenNext

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


Gord Dibben MS Excel MVP

On Sat, 23 Feb 2008 11:01:00 -0800, Walter
wrote:

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.

replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER
 

Wow ... terrific advice ... many thanks!!
"Gord Dibben" wrote:

If you can't get rid of it at the source you can break it out once in Excel.

Try DataText to ColumnsDelimited byOther......enter a hyphenNext

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


Gord Dibben MS Excel MVP

On Sat, 23 Feb 2008 11:01:00 -0800, Walter
wrote:

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.