Converting units

Originally Posted by Teethless mama

Try this one, no helper columns is required

=CONVERT(LEFT(A2,FIND("'",A2)-1)*12+SUBSTITUTE(MID(A2,FIND("'",A2)+1,9),"""",),"in","m")

Thanks for your answer, I was hoping that there was a formula in order to do it without having to separate columns...
thanks again.