View Single Post
  #2   Report Post  
Marc
 
Posts: n/a
Default

If I understand correctly, list #1, 10,000 names inclusive of #2 5,000
WITHOUT e-mail addresses. You want to separate those out and/or delelte them
from your list #1.

Guessing you have a column in list #1 that is for e-mail address. 5000 of
them don't have anything listed in this column. Therefore, you could sort by
"e-mail address" column. In menu go to "Data" and then "Sort." That way all
rows with e-mails would list all together and you could delete the "non
e-mail rows." Then resort your list #1 as you want...by name?

Hope it works!

Marc