Hi there,
I have a large list of email contacts saved on an excel file (circa 4000). Over time the need to update this list has arisen, as some of these emails no longer work and for some, they have new email adresses. I have the old list, a list of the emails to be deleted, and the list for the emails that should change(this list has both the new and old emails). I am looking for a formula which can easily read the new lists and replace/ delete the required emails.
I am using excel (2007) in German but this is not an issue,
Can anyone Help?
Hüdson
I have a large list of email contacts saved on an excel file (circa 4000). Over time the need to update this list has arisen, as some of these emails no longer work and for some, they have new email adresses. I have the old list, a list of the emails to be deleted, and the list for the emails that should change(this list has both the new and old emails). I am looking for a formula which can easily read the new lists and replace/ delete the required emails.
I am using excel (2007) in German but this is not an issue,
Can anyone Help?
Hüdson