| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete all non-numerics
I'm in the middle of a macro to extrapolate a row of numbers and then use the
numbers as a basis to extrapolate more information. I'm trying to delete all the blank cells and cells with text in them, leaving behind only the numbers. Is this possible? The worksheet from which the column is pulled is formatted as general. Thanks, Mrs. Robinson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Numerics only | Excel Discussion (Misc queries) | |||
| Remove Non-Numerics from String | Excel Programming | |||
| How to forecast non-numerics? | Excel Worksheet Functions | |||
| Formula with text and numerics | Excel Worksheet Functions | |||
| Making certain a cell contains numerics | Excel Programming | |||
![Mrs. Robinson[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
