| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to extract numbers from imported cell with text and number
thanks mike! (:
unfortunately, i forgot to add that i need the data to keep refreshing every hour. i tried using 'text to columns' but after splitting, cells are removed from the imported data and cannot be refreshed. "Mike" wrote: Have a look at Data - Text to columns. Mike "jyin" wrote: does anyone know how to extract the number from an imported cell if the cell contains both text and numbers? eg. the cell contains "USD 30.79 (March 27, 2007)" but i want to use only 30.79 in a formula in another cell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Extract numbers from cell with Text and Numbers | New Users to Excel | |||
| How do I extract numbers from a cell with both text and numbers? | Excel Worksheet Functions | |||
| extract numbers from cell containing text & numbers | Excel Worksheet Functions | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Threaded Mode
