Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract number value from a String. 4'6'' to 4.5
Thanks a lot dude. It's working properly.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXTRACT NUMBER FROM STRING | Charts and Charting in Excel | |||
Extract number from text string based on number's format? | Excel Discussion (Misc queries) | |||
Extract number from text/number string.. | Excel Discussion (Misc queries) | |||
Extract Only Number From A String | Excel Programming | |||
How to extract the Number from a String | New Users to Excel |