CODEWITHSUNDEEP
excel
Charles Yeung
Charles Yeung

Reputation: 38795

Excel formula to check if any part of B1 is also in A1 then print true

Suppose I have the 2 cell as below

A1: Hello World
B1: orl

How can I use a formula to check if any part of B1 is also in A1 then print true?

The formula may look like
if any part of B1 is also in A1 then print true

Thanks

Upvotes: 0

Views: 1584

Answers (1)

Tim
Tim

Reputation: 35943

=ISNUMBER(FIND(B1,A1))

will print out TRUE if A1 contains B1, or FALSE if it doesn't

Upvotes: 4

Related Questions