How to remove a row from excel that contains digits?

[PrankurJoshi]

Hi @Ibra

dt.AsEnumerable().Where(Function(row) IsNumeric(row(column).ToString.Trim)).ToArray()
will return an array of DataRows

See this

Filtering only numeric values through LINQ

Hi If we have a column with numeric, alphabetical and alphanumeric values, how can we use LINQ to filter out only the numeric values? I tried something like DT.Select(“ColumnName NOT LIKE”+regex) but it isn’t working.

Thanks,
Prankur