| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to extract number from cells in excel (function in Excel or VBA?)
Dear all,
I want to get only number from cells in Excel, for example, "$123m/di" in a cell, I want "123" left. I tried Value function in Excel, it doesn't work. I remeber I'v seen a article before, which mentioned how to extract number or text from cells in Excel. But I forgot how to do it totally. Or can I do it in some function? Thanks. JIANG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to extract the number of pages in a cell (Excel 2003) | Excel Discussion (Misc queries) | |||
| How do I extract the decimal places from a number in excel? | Excel Worksheet Functions | |||
| How do extract cells from hundreds of excel files and put in one n | Excel Discussion (Misc queries) | |||
| Excel Changes Text Cells to Number Cells When Importing XML | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Threaded Mode
