How to do perform "contains" in Excel

1
votes

Cell A contains users email address and B contains domain. (ex: email as [email protected], domain is gmail. email as [email protected], domain is yahoo etc).

I want to find out domain and the email address matching or not. I am not quite sure how to perform this in excel.

2
sqlexcelexcel-formula

2 Answers

4
votes

use Search and Isnumber:

=ISNUMBER(SEARCH(B1,A1))

enter image description here

0
votes

Using find and search :

=IFERROR(IF(FIND("@",A1)+1=SEARCH(B1,A1),TRUE,FALSE),FALSE)

enter image description here