In column A1, I have 12'-5 (general) and want to covert to total inches (65). I have tried several formula's but to nothing seems to work. Do I need to set the solution column to specific type (i.e general) or am I missing something :-( ...
Tried : =(1*(LEFT(A1,FIND("-",A1)-1)*12+MID(A1,FIND("-",A1)+1,2)))+IF(LEN(A1)=LEN(SUBSTITUTE(A1,"1/2",""))
and nothing happened?
Bookmarks