| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| Replacing a number value with text from array | Excel Worksheet Functions | |||
| Replacing dash in item number | Excel Discussion (Misc queries) | |||
| Replacing a number with a description in Excel | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
