Thread: convert feet & inches to decimals
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default convert feet & inches to decimals
=LEFT(A1,FIND("-",A1)-2)+SUBSTITUTE(MID(A1,FIND("-",A1)+1,5),"""","")/12


"Roderick" wrote:

example: I need to insert 3'-2" into one cell and the result shown in another
cell would be the equivalent in decimals of feet
--
Estimator
Reply With QuoteReply With Quote