Filter by "contains"

[Moonscarlet]

Hello,

I've tried "_Excel_FilterSet"  "_Excel_FilterSet($File,Default,Default,1,"word")"  to filter in excel and it works great but I can't seem to find how to make it filter a certain column with a substring instead of the whole string, is that possible?

Thanks in advance.

[water]

This filters all cells that contain "Word" in column A:

$oFilter = _Excel_FilterSet($oWorkbook, Default, "A:A", 1, "*Word*")

 

[Moonscarlet]

4 minutes ago, water said:

This filters all cells that contain "Word" in column A:

$oFilter = _Excel_FilterSet($oWorkbook, Default, "A:A", 1, "*Word*")

 

Thanks a lot

[water]