Extract number value from a String. 4'6'' to 4.5
 

Hello

I wanted to know if I could extract the number values from a Strins.
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.
Can anyone help me out.

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

Extract number value from a String. 4'6'' to 4.5
 

Thanks a lot dude. It's working properly.