View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan M Alan M is offline
external usenet poster
 
Posts: 69
Default 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?