Identifying duplicate Characters

[AppSupportKarl]

Hi Guys,

i need a bit of code that will identify if a cell contains more than one "@" (to help in my validation of email addresses).

at the moment, i'm using:

Please Login or Register  to view this content.

but this obviously returns nothing unless the cell in question only contains "@" on its own. any help?

[Kyle123]

maybe:

Please Login or Register  to view this content.

[gazzabj]

=LEN(A1)-LEN(SUBSTITUTE(A1,"@",""))

This is a function you could use. Just check if its more than 1.

[Kyle123]

Yep, use gazzabj's solution if you're using it on a sheet, but mine should be faster in code.

Though it really won't matter if you're only calling it once

[Trebor76]

Try this:

Please Login or Register  to view this content.

HTH

Robert

[Kyle123]

Alternatively, this will validate most email addresses

Please Login or Register  to view this content.

[Trebor76]

Hey Kyle123,

That email UDF is pretty cool

Thanks for posting it.

Robert

[AppSupportKarl]

Cheers guys, i used Kyles first suggestion succesfully, but your second function seems extremely helpful... To the batcave!!!