Hi,

Am Sun, 28 Sep 2014 09:12:45 -0700 (PDT) schrieb :

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.

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


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional