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?

06-27-2011, 04:34 AM

Colin Legg Colin Legg is offline

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

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Hi,

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:13 AM.