problem with fractions to decimal

  • Thread starter Thread starter roondog248
  • Start date Start date
R

roondog248

I'm creating a spreadsheet that tracks and records line moves in Vegas.
when I copy and paste the data into a sheet, the point spread (+3½) and money line (-105) are both entered into the same cell. like +3½ -105

to separated the two I using =Left(B2,3) to extract +3½ into cell D2

but now I can't get add or subtract anything to that number because the ½is there and the sheet recognizes it as a text, not a number.

I tried to format it as a fraction with #?/? didn't work
Tried to use find ( and replace, that didn't work.



Here is the sheet. feel free to edit it if you have a solution
https://docs.google.com/spreadsheets/d/1cm05sGjrm91EE6mMeE5gVEg8MwCufH-03h4T4-XXdNY/edit?usp=sharing

thanks.
 
Hi,

Am Sun, 28 Sep 2014 09:12:45 -0700 (PDT) schrieb (e-mail address removed):
to separated the two I using =Left(B2,3) to extract +3½ into cell D2

but now I can't get add or subtract anything to that number because the ½ is there and the sheet recognizes it as a text, not a number.
Click to expand...

1/2 is one character.
Try:
=IF(RIGHT(B2,1)="½",--(LEFT(B2,2))+(LEFT(B2,1)&1/2),B2*1)


Regards
Claus B.
 
Back
Top