How to delete rows excel that contain unwanted data

Help StudioX
,
2

@Nur_Amin
Please try this in set variable

dt = dt.AsEnumerable.Where(function(x) IsNumeric(x("ain").ToString.Trim)).CopyToDataTable

Dt is the datatable in which you have

Left of equals symbol on left side of set variable and right of equals symbol on right side

Use advanced editor to give this formula

Cheers