Any way to have Similar function as Text Filter function in excel

Filter data Table can only put filtered data to another sheet instead of filtering in the original sheet with uncheck or check the data we want. Any way we can have the same function as “Text Filter”? Thanks.


Try selecting the whole column and change the format to general or text ,

Hi @li.yu

you can write an excel vba macro using invoke VBA activity, that will filter the data in excel itself…


Thanks, but I want to filter column H, which with value out, than to have Column H - Column G, the result will be in column I, after the calculation, will remove filter option.

thanks, but I have little VBA experience.

what you have to apply in the filter…

filter all values not blank.

Please find the reference

Sub filter()
    Range("A1:H" & Cells(Rows.Count, 1).End(xlUp).Row).AutoFilter Field:=4, Criteria1:="<>"
End Sub

it will filter in 4th column change column number as you want,




yes, it works, very appreciated!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.