Invalid Email Id

[hardeep.kanwar]

Hi!

I have 21000 E-Mail ID's

But Some have in Wrong Format, Now i want to know which one are InValid E-Mail ID's

Right Now i am Using this<TABLE style="WIDTH: 161pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=215><COLGROUP><COL style="WIDTH: 161pt; mso-width-source: userset; mso-width-alt: 7862" width=215><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 161pt; HEIGHT: 15pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" id=td_post_1507436 class=xl67 height=20 width=215>ISNUMBER(FIND(".",A2,FIND("@",A2)))



</TD></TR></TBODY></TABLE>Formula

but its not Working Properly, It show True Even The EMAIL-ID IS WRONG.

See Below

Sheet3

image removed


Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4


Thanks in Advance

 

[hardeep.kanwar]

building on Sandeeps' solution,

Function ValidateEmail(ByVal Email As String) As String
With CreateObject("vbscript.regexp")
    .Global = True
    .Pattern = "^[\w-\.]+@\w+\.[a-z]+(\.[a-z]+)?$"
    If .test(LCase(Email)) Then
        ValidateEmail = "Valid Email"
    Else
        ValidateEmail = "Invalid Email"
    End If
End With
End Function

this allows, any alphanumeric, period (.), hypen and underscore in both the user name and the domain name, the suffix of domain name (.com,.co.in) can contain only alphabets

Hey Sanrv1f

Right now i am Out of Station, and don't have Mine Data

Will be Back As Soon As Possible

HopeFully Your Code Will Work for Me.

Also Thanks to Sandeep

 

[Joe4]

Some have Real and Some Don't have.

Could you Pls Remove all the Images for me

I will be Very Thankful to You.

I think I have removed them all.

In the future, please be careful not to post personal or sensitive information such as email addresses, phone numbers, addresses, or social security number.

Believe it or not, we once had a non-member find some personal information about themselves posted here, and they were LIVID! You don't want to get in trouble with your clients, employers, etc either.

 

[hardeep.kanwar]

Thanks for the Advice

Definitely, I Will Care while Posting Examples


Thanks Again

 

[techexpressinc]

Re: Invalid Email Id - dashes are giving me the Invalid Email -

A valid email i.e. Rus@abc-d.com will flag as invalid although it is valid does anyone know a fix?
Thx
Russ

Hey Sanrv1f

Right now i am Out of Station, and don't have Mine Data

Will be Back As Soon As Possible

HopeFully Your Code Will Work for Me.

Also Thanks to Sandeep