I have 1 column with 600 entries where I need to move, to a new column, only those entries which has a keyword "test" in them, but not exact match. Looking for a Google Sheets formula, Excel works as well.

CodePudding user response：

Assuming your column is A, try

=query(A:A,"where A like '%test%' ")

CodePudding user response：

or:

=FILTER(A:A; A:A="test")