delete all cells with numbers in them

You would have to use VBA to actually delete them automatically, but you could do it manually, if your list isn't too long...

Assume your list is in A1:A10. In cell B1, enter this formula, then fill down to B10:

=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A1)),"",A1)

You will now have a list that has blank cells... those were the cells that had numbers in them from column A.

You could then copy and 'Paste Special: Values' wherever you need the new list. Of course, there are the blanks to deal with, which can be easily deleted.

If you have a LOT of data, a VBA solution would be better.

- Moo