| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing non numeric rows
HI I have a spreadsheet imported from a csv file . In column A I have a list
of stock numbers which are 6 digit numerals. The file also has header columns and page headers etc which I need to remove so that I have a straight list of stock reocrds only to be able to sort etc. To do this I need to select all rows which do not have the numeric stock number value in column A. is there code to select non-numeric values? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Non-Numeric Characters - Automatically - How? | Excel Discussion (Misc queries) | |||
| removing leading zeros in numeric fields | Excel Discussion (Misc queries) | |||
| Removing Non-Numeric Characters | Excel Discussion (Misc queries) | |||
| Delete rows with numeric values, leave rows with text | Excel Programming | |||
| removing a row if it is non numeric | Excel Programming | |||
Threaded Mode
