finnstone
asked on
find a word in a cell
in column B - i have the word i want to search
in column C - i have a long bunch of text
i want to search the word in column B in the column C
thanks for any formulas!
in column C - i have a long bunch of text
i want to search the word in column B in the column C
thanks for any formulas!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Search function is to match text in case insensitive, to match text in case sensitive, you would need Find function.
Search:
Find:
Search:
=IF(ISERROR(SEARCH(B2,C2)),"Not Found", "Found")
Find:
=IF(ISERROR(FIND(B2,C2)),"Not Found", "Found")
29014419.xlsx
Excel SEARCH Function
https://exceljet.net/excel-functions/excel-search-function