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 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.
 
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)
 
=IF(ISERROR(FIND("@",A1)),FALSE,TRUE)

Happy Holidays to you, too

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If function + wildcard question 6
Sum with multiple conditions and wildcard 2
Use a wildcard within edit/replace 4
Using ? in criteria 2
Wildcard in the Replace function 2
If formula and text search 14
Wildcard for any number in conditional formula 3
Wildcard Character in IF formulas 2

Back
Top