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

Learner7 · #1 06-27-2011, 01:41 AM

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.

Colin Legg · #2 06-27-2011, 04:34 AM

Hi,

Filter column B for values greater than 1000 and then delete the visible rows.

Learner7 · #3 06-27-2011, 05:44 AM

Quote:

Originally Posted by Colin Legg

Hi,

Filter column B for values greater than 1000 and then delete the visible rows.

Wonderful! It is quite nice and saved a lot of time.

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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