A **total** length of 8... including the @ sign? If so, change your
condition formula to this...

=ISNUMBER(--LEFT(C3))*(LEN(C3) =8)*(NOT(ISERROR(FIND("@",C3))))

Rick


"Theo" wrote in message
...
Yes - I am trying to use data validation, but struggling with the format.
I have this for a custom validation:
=AND(LEFT(C3, 1) ="#",LEN(C3) =8)
This requires a # and total length of 8.

So I was hoping to use something like the above, except requiring the "@"
somewhere WITHIN and the length LE 32.
Any ideas?

"ryguy7272" wrote:

Not 100% sure about your need, but see if Data Validation gives you
what
you want.

Regards,
Ryan--

--
RyGuy


"Theo" wrote:

I want to be sure that the entry into a cell is an email address - is
there a
way to ensure that at least one character (any character) is an at sign
(@).
Any ideas appreciated!!!!