Forum Discussion
adminragnar
Nov 09, 2024Copper Contributor
Search for multiple keywords in Excel?
Hello, I have a column with many rows containing different texts. I would like to be able to search all the rows in that column for any one of a number of different keywords. For example: I...
- Nov 09, 2024
Most probably you shall use semicolons instead of commas an function names will be different in your locale. Plus it shall be Excel 365, 2021 or 2024.
Please open attached file and check formula in G2, it will be shown in your locale notation.
adminragnar
Nov 09, 2024Copper Contributor
Hello and thank you for your reply!
I am very much a beginner at Excel. If I paste the formula as I have done in the screenshot, is that correct?
- SergeiBaklanNov 09, 2024Diamond Contributor
Most probably you shall use semicolons instead of commas an function names will be different in your locale. Plus it shall be Excel 365, 2021 or 2024.
Please open attached file and check formula in G2, it will be shown in your locale notation.