Perform a function on results of a function?

[VegasVixen]

Hello & thanks in advance for your help!

I have a worksheet which is importing data off a webpage. The data I'm interested in is the football score which imports as "48-14".

I was created 2 new cells to get the data (score) separated as "points for" and "points against", using a formula like this:
=SUBSTITUTE(E23,RIGHT(E23,3),"") and =SUBSTITUTE(E23,LEFT(E23,3),""), so now I have 2 cells, one which has 48, the other 14

My problem is, as I get more game scores and they fill the column, I want to get the MEDIAN of the 4 scores and i get a #NUM error when trying to do the median function. Is it because I'm trying to do a function on the results of a function? I've even tried to move the number to another area by simply using "=" and creating a column of scores there to try to do the median function on but I can't get the median function to work on any data except numbers I actually type in.

Also, I have made sure all cells are formatted to Number > General, so it's not trying to perform it on a text cell.

Please advise, thank you!

 

[RoryA]

It's because the result of the formulas is a text representation of a number, not an actual number.
You could use:
=LEFT(E23,FIND("-",E23)-1)+0
and:
=MID(E23,FIND("-",E23)+1,LEN(E23))+0

 

[VegasVixen]

Thanks for yur reply... I also found I can just use the "text to columns" button on the data tab to take care of this separation. I click the box with the score (say 14-41), click text to colums button, choose delimited, then "spcae" and "other" "-" as my delimeter then tell it where to put the separarted numbers. So many tricks still to learn in this software!