hmmmmm it seem i still am hving problems....heres the corrections to it
=LEFT(A37,FIND(" ",A37)-1)+((MID(A37,FIND(" ",A37)+1,LEN(A37)-FIND("
",A37))/12))

"IC" wrote:


"go_chrisg" wrote in message
...
I have an assignment that shows me this equation but it doesnt seem to
work,
=LEFT(A1,FIND("",A1)-1)+((MID(A1,FIND("",A1)+1,LEN(A1)-FIND("",A1)-1))/12)

Chris

It's close, but not quite right. Firstly I assume A1 is in the format
ft<spacein. Your formula needs to look for the space, so you need to add a
space between all 3 instances of "". Secondly, the final "find" argument is
wrong. As it stands, it will only pick up the first digit after the space
for the inches. Deleting the -1 from after the final A1 will cure this.

Ian