IF function + Wildcard question

I

illhawaiian

I'm trying to locate any and all email addresses in column A using the
IF function and the wildcard (*)

=IF(A1="*@*", TRUE, FALSE)

However, all function results appear as "FALSE" when it should be
"TRUE"

Any suggestions?

Thanks in advance and Happy Holidays.
 
B

Bob Phillips

Try this formula

=NOT(ISERROR(FIND("@",A2)>0))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
N

Niek Otten

=IF(ISERROR(FIND("@",A1)),FALSE,TRUE)

Happy Holidays to you, too

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top