Thread: Extract number value from a String. 4'6'' to 4.5
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Extract number value from a String. 4'6'' to 4.5
Hi,

Am Sat, 16 Jan 2016 21:42:09 -0800 (PST) schrieb
:

For Eg:- 4'6'' must be taken as 4.5
10'11'' must be taken as 10.92
Like the feet number as it is, but the number in
Inch to be divided by 12.

your string in A1. Try:

=LEFT(A1,FIND("'",A1)-1)+SUBSTITUTE(MID(A1,FIND("'",A1)+1,99),"''",)/12

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote