convert feet and inchs to inchs only

[Guest]

Trying to convert from 15'6" to inchs only, is this possible and how do I do
it? The info is in a2 need to see the answer in a3

 

[Dewi]

Trying to convert from 15'6" to inchs only, is this possible and how do I do
it? The info is in a2 need to see the answer in a3

how is the 15'6" getting into A2?

If it can be put in A2 for feet and A3 for inches with the answer in
A4 then it's a doodle

in a4 =(a2*12)+a3

 

[Biff]

Hi!

Here's one way:

=(LEFT(A2,FIND("'",A2)-1)*12+SUBSTITUTE(MID(A2,FIND("'",A2)
+1,255),"""",""))

Biff

 

[Guest]

Thanks alot, I knew somebody out there could figure it out.