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

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.

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.