Excel Filter to remove blank text and " / /"

[wai_sie.yow]

I had browsed the past postings in this community and I still haven’t found the answer.

I’m looking for a solution, to filter out the blank text and also " / /" from my data table.

I only want the dates. Have re-worked the filter many times. Still not getting the result I want. The blank text and " / /" are still being selected.

Hope someone can lend their expertise here. Thank you

[THIRU_NANI (NaNi)]

Hey!

Try this:

Null

Datatable.select("[coulmn name]<>'" ").CopyToDatatable

Take one Filter DataTable:

Does Not Contain / /

OR

Made the changes in filter data table

You have to keep OR not AND

Try this and let me know

Regards,
NaNi

[wai_sie.yow]

Hi Thiru_Nani,

I have changed the filter from AND to OR. The result is the same.