If function + wildcard question

[illhawaiian]

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

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

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

Any suggestions?

Thanks in advance and Happy Holidays

 

[Dave R.]

your formula looks only at A1 (you say 'column'), and the IF statement is
not going to search text like that on its own.

try

for the whole column
COUNTIF(A1:A100,"*@*")

or if you want it to look only at a1
COUNTIA(A1,"*@*")

this will give 1 or 0s, instead of true and false.

Happy new year.

 

[Dave R.]

typo, 2nd formula should also be COUNTIF.

 

[Jason Morin]

Here are 2 ways:

=IF(COUNTIF(A1,"*@*"),TRUE)
=ISNUMBER(FIND("@",A1))

HTH
Jason
Atlanta, GA

 

[Niek Otten]

See answers in other newsgroups. Please don't multipost.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[illhawaiian]

Thank you Dave!

"your formula looks only at A1 (you say 'column'), and the IF statement
is not going to search text like that on its own."

I forgot to mention the relative reference used in column B to include
all cells in column A (basically the same formula was applied to the
entire column)

"COUNTIA(A1,"*@*")

this will give 1 or 0s, instead of true and false."

This worked perfectly (minus the "I" in countIA), thanks again for your
help.

Happy New Year!

 

[illhawaiian]

"See answers in other newsgroups. Please don't multipost"

Cool, I won't.

"This worked perfectly (minus the "I" in countIA),"

I meant to say countif too.

Thanks Jason and Dave.