If Cell Includes

[kinstlinger]

I've been given a very large spreadsheet which includes email addresses,
some good, some bad, some in ancient form.

How can I make a statement which checks the various cells to see if
they include (or don't include) an '@' symbol ?

 

[Biff]

Hi!

This formula will return TRUE if A1 contains an "@" sign, FALSE if it does
not:

=ISNUMBER(FIND("@",A1))

Or, you can wrap that inside an IF function for a return of either Yes or
No:

=IF(ISNUMBER(FIND("@",A1)),"Yes","No")

Biff

"kinstlinger" <[email protected]>
wrote in message
news:[email protected]...