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..

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..

so that is my problem, i dont know how email address should be formatted.. i
assume that it must have @, no spaces, i know it must have at least one dot
and i think theres limit for the numbers of dots it may have, and some other
thing but i dont know them, i believe that theres is already function or
somthing that validate email because theres many websites or applications
that tells you if theres a problem with the email address that you inserted..
so this is what i looking for..

thanks for the reply..

yakir.

"Gord Dibben" wrote:

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..



.