If function + wildcard question

  • Thread starter Thread starter illhawaiian
  • Start date Start date
I

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
 
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.
 
Here are 2 ways:

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

HTH
Jason
Atlanta, GA
 
See answers in other newsgroups. Please don't multipost.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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!
 
"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.
 
Back
Top