Hi,

How can I delete the contents (values) of a cell in a column if the cell value is more than 1000?

For example: I have the data in Column (B) like the following:

50245
40365
865421
200
65987
999
800
When I apply the condition ...50245, 40365, 865421, 65987 should be deleted and the remaining should be as it is.

I have huge data to work it out. Please do help.

Thanks.