| 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. |
| 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 | |||
Threaded Mode
