Prev: form validation determines which sheet to add data
Next: Copy & paste formula
From: yakir on 13 May 2010 08:30
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..



From: Gord Dibben on 13 May 2010 09:50
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 <yakir(a)discussions.microsoft.com>
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..
>
>

From: yakir on 18 May 2010 20:13
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 <yakir(a)discussions.microsoft.com>
> 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..
> >
> >
>
> .
>
 | 
Pages: 1
Prev: form validation determines which sheet to add data
Next: Copy & paste formula