"yonny" wrote:
here is my structure
--------------------------------------.
G8 | H8 | I8 | J8 | K8 |
--------------------------------------.
27 1/2 | 27 | 1/2 | 0.5 | 27.5 |
--------------------------------------.
Here are the formulas im using
in H8 - =TRIM(LEFT(G8;SEARCH(" ";G8)-1)) gets 27
in I8 - =TRIM(RIGHT(G8;SEARCH(" ";G8)+1)); gets 1/2
in J8 - =LEFT(I8;FIND("/";I8)-1)/MID(I8;FIND("/". gets 0.5
in K8 - =SUM(H8+J8) gets 27.5 which is what I was after

however I dont know enough excel to combine all of the
formulas into one and get the results in H8 so it looks like
--------------------------
G8 | H8 |
--------------------------
27 1/2 | 27.5 |
--------------------------

That depends on the type of value you have in G8: text or numeric.

Since the SEARCH seems to work, I assume you have text in G8. In that case,
put the following formula into H8:

=--G8

formatted as General or Number with some number of decimal places.

If G8 is numeric (formatted as Fraction) -- ISNUMBER(G8) returns TRUE -- all
you need in H8 is =G8 formatted appropriately.