The trick being.............how will Excel know the cell's text is not a
valid email address.

Did you have some format in mind that Excel should look for?

Like a missing @ or similar?


Gord Dibben MS Excel MVP


On Thu, 13 May 2010 05:30:01 -0700, yakir
wrote:

i have a excel .CSV file that Gmail generated for me with my contacts in..
what i want to do is function that go over all the contacts emails one by
one and deletes all missformated addresses that cannot be use to send email
for them.. somthing like :

if (the cell's text is not an valid email address)
{
delete the cell ;
}

to be honest i dont know much about excel so i need somthing from
scratch..

thank you all very much..