Deleting Cells Based on Numeric Values

[madhuchelliah]

Hello Guys, I want to delete the cell contents in H column that doesn't contains numerical value(Should keep only numeric and alpha numeric contents). Thank you.

 

[mole999]

you could test with either ISTEXT or ISNUMBER, what it won't find is the alphanumeric which is treated as text, unless you look for numbers always first or always last (or similar)