In column A1, I have 12'-5 (general) and want to covert to total inches (65). I have tried several formula's but to nothing seems to work. Do I need to set the solution column to specific type (i.e general) or am I missing something :-( ...
Tried : =(1*(LEFT(A1,FIND("-",A1)-1)*12+MID(A1,FIND("-",A1)+1,2)))+IF(LEN(A1)=LEN(SUBSTITUTE(A1,"1/2",""))
and nothing happened?
Last edited by shernandez; 07-08-2009 at 11:58 AM.
Welcome to the forum.
=LEFT(A1, FIND("'", A1)-1)*12 + MID(A1, FIND("-", A1)+1, 2)
Entia non sunt multiplicanda sine necessitate
I placed your formula in cloumn b1 and it has an error .. any other suggestions
Yes -- post a workbook.
Thank You ... I attached the sample excel worksheet
If you put SHG's formula in B1 you get an error because A1 has the word "Length" in it, not a measurement. Try putting it in B2 and adjust all of the references of A1 to A2. Once you do that the formula should work and you can fill it down column B as far as necessary.
=LEFT(A2, FIND("'", A2)-1)*12 + MID(A2, FIND("-", A2)+1, 2)
Re: Convert feet and inches to inches
I know that this seems simple ... but here is what I get (see attachment)
No attachment...
Here it is ... Thanks
Try this formula without the spaces:
=LEFT(A2,FIND("'",A2)-1)*12+MID(A2,FIND("-",A2)+1,2)
If that doesn't work, are you using a non-english version of Excel? If so, you need to replace the commas with semi-colons:
=LEFT(A2;FIND("'";A2)-1)*12+MID(A2;FIND("-";A2)+1;2)
Also, in non-english versions of Excel, LEFT/MID/FIND functions may be called something else.
If that still doesn't work, try uploading your spreadsheet, not a picture of the spreadsheet.
Try copying the formula directly from the post. You've mis-entered it.
Attached is my test workbook. This is an english version.
See attached.
I'd suggest one small change, a 3 instead of a 2 at the end, i.e.
=LEFT(A1, FIND("'", A1)-1)*12 + MID(A1, FIND("-", A1)+1, 3)
This will ensure that values like 12'- 11 are correctly converted
I tried the formula and excel rejects it! I did break the formula down (looks good) but to no avail... Any suggestions? I posted the error on a previous thread.
There no formula in your workbook.
The workbook would not let me save it because it is not working (placed it in A2).
=LEFT(A1, FIND("'", A1)-1)*12 + MID(A1, FIND("-", A1)+1, 3)
Did you look at the example in post#13?
yes ... same results (still having problems)
If you use a non-English version of Excel, did you try changing the commas to semicolons?
It is an english version
Hi ... Did you get a chance to test the formula on the sample worksheet I attached ... Thank you
see attached.....in B1 copied down
I just registered to say ... Thank you, it was very helpful to me... I use it to convert min to sec ... It work good.
how to convert 4.11 Feet (4 Feet & 11 Inches) to 59 inches...........
Welcome to the Forum Rupak007, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks