I have a similar task in that I have approx 18,000 rows of data. In column A, for each row, there is either a code number (all numbers) or the text "#NA". All the rows with code numbers correspond to data I already have. As such I would like to eliminate those rows that have a numerical value in column A and keep all the rows that have #NA. Normally I would just sort the data on column one, but this file is not clean and some of the data has "wraped around" to the next row. As such I really need a search routine to delete the rows with the numerical code and leave the rows with the #NA (BTW, fortunately the wrapped rows also start with #NA). thanks!!