Excel FILTER command with WILDCARDS or FILTER if cells contain partial text.

Filter command does not support * (Wildcards) but you can do this function using standard excel commands in conjunction with the new excel FILTER command. i.e. filter all cells containing "ABC" somewhere in the text