"Contains" formula

[erenkey]

Is there a formula in Excel that will tell me if a cell contains certain data? I have a list of people in a spreadsheet. some of the people have email addresses and some don't. I want to find out who has and email address and who does not by using some type of formula that will return at 1 if the email address column contains the @ symbol. Is this possible without using a macro?

 

[VoG]

Try like this

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

 

[Jonmo1]

Try

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

Hope that helps.

 

[taurean]

Use FIND formula combined with IF like:
=IF(ISERROR(FIND("@",A1,1)),"Not an Email ID!","Bingo!")

 

[pgc01]

Hi

Try:

=COUNTIF(A1,"*@*")

 

[T. Valko]

Is there a formula in Excel that will tell me if a cell contains certain data? I have a list of people in a spreadsheet. some of the people have email addresses and some don't. I want to find out who has and email address and who does not by using some type of formula that will return at 1 if the email address column contains the @ symbol. Is this possible without using a macro?

Yet another one...

=IF(COUNT(FIND("@",A1)),1,"")

 

[erenkey]

thank you everyone for your replies.

 

[T. Valko]

thank you everyone for your replies.

You're welcome. We appreciate the feedback!