With this text: 5'-6 3/4")
in A1, the formula =--LEFT(A1,FIND("'",A1)-1) returns the numeric value 5
The double negation converts text to number

The formula
=--LEFT(MID(A1,FIND("'",A1)+2,256),LEN(MID(A1,FIND("' ",A1)+2,256))-1)
returns 6.75 also as a number

Combining them as
=ROUND(LEFT(A1,FIND("'",A1)-1)+LEFT(MID(A1,FIND("'",A1)+2,256),LEN(MID(A1,FIND ("'",A1)+2,256))-1)/12,2)
gives 5.56

I tested the formula with 12'-5 1/8" and got the correct value of 12.43
But please do more testing
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"sammy" wrote in message
...
Hi All,
Is there anyway to convert an architectural units text with feet, inches
and
fractions of an inch, like (5'-6 3/4") to feet and decimals of a foot,
like
(5.56)?
TIA,
Sal