How can I delete the content of a cell in column if the cell value is more than 1000?

		Microsoft Office Forums > Microsoft Excel > Excel
How can I delete the content of a cell in column if the cell value is more than 1000?

FAQ

Thread Tools

Display Modes

06-27-2011, 01:41 AM

Learner7

Windows XP How can I delete the content of a cell in column if the cell value is more than 1000?

Office 2007

Advanced Beginner

Join Date: May 2010

Posts: 51

How can I delete the content of a cell in column if the cell value is more than 1000?

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell content splits	Mahen	Excel	2	05-15-2011 01:53 AM
How to delete first 6 Digits and one Space from a CELL?	Learner7	Excel	3	08-10-2010 04:06 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM
How do I reference a merged cell in a multi column & row table in MS Word ('03')?	jihanemo	Word Tables	0	03-18-2009 08:33 AM