"go_chrisg" <[email protected]> wrote in message
news:[email protected]...
> 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<space>in. 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
Bookmarks