Forum Discussion

adminragnar's avatar
adminragnar
Copper Contributor
Nov 09, 2024
Solved

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...
  • SergeiBaklan's avatar
    SergeiBaklan
    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.

Resources