Formula for converting feet and fraction of inches to meters

[jvwm]

What is the formula in calculating meter from feet and fraction of inches??

 

[rollis13]

Wouldn't column HEIGHT(cm)/100 be okay ?

 

[rollis13]

Elsewise, supposing your HEIGHT(ft-in) is in cell G3 (and looks like text) then use this formula in H3:
=ROUND((LEFT(G3,FIND("'",G3)-1)*12+ABS(SUBSTITUTE(MID(G3,FIND("'",G3)+1,LEN(G3)),"""","")))/39.701,2)
or even:
=ROUND(CONVERT(LEFT(G3,FIND("'",G3)-1)*12+ABS(SUBSTITUTE(MID(G3,FIND("'",G3)+1,LEN(G3)),"""","")),"in","m"),2)

 

[rollis13]

Sorry, typo in the first formula:
it should be 39.3701

 

[jvwm]

Elsewise, supposing your HEIGHT(ft-in) is in cell G3 (and looks like text) then use this formula in H3:
=ROUND((LEFT(G3,FIND("'",G3)-1)*12+ABS(SUBSTITUTE(MID(G3,FIND("'",G3)+1,LEN(G3)),"""","")))/39.701,2)
or even:
=ROUND(CONVERT(LEFT(G3,FIND("'",G3)-1)*12+ABS(SUBSTITUTE(MID(G3,FIND("'",G3)+1,LEN(G3)),"""","")),"in","m"),2)

Am I doing right? but still it's error? but correct me if im wrong

 

[jvwm]

Elsewise, supposing your HEIGHT(ft-in) is in cell G3 (and looks like text) then use this formula in H3:
=ROUND((LEFT(G3,FIND("'",G3)-1)*12+ABS(SUBSTITUTE(MID(G3,FIND("'",G3)+1,LEN(G3)),"""","")))/39.701,2)
or even:
=ROUND(CONVERT(LEFT(G3,FIND("'",G3)-1)*12+ABS(SUBSTITUTE(MID(G3,FIND("'",G3)+1,LEN(G3)),"""","")),"in","m"),2)

=ROUND(CONVERT(LEFT(G3,FIND("'",G3)-1)*12+ABS(SUBSTITUTE(MID(G3,FIND("'",G3)+1,LEN(G3)),"""","")),"in","m"),2) WOW!!! HEHE thank you this formula works!! i have tried different formula just to solve this! gosh thank you !

 

[rollis13]

Even the first does work, you forgot to copy the last ,2 .
Anyway, thanks for the positive feedback, glad having been of some help.