| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete cells containing specific data?
How can you delete all cells containing specific data in a huge spreadsheet?
For example, delete all cells containing the word "hotfix." Kind of like search & replace, but that function can't delete cells that contain certain text. Thanks for any help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete cells containing specific data?
On Thu, 22 Mar 2007 13:22:22 -0700, Mobility Guy
wrote: How can you delete all cells containing specific data in a huge spreadsheet? For example, delete all cells containing the word "hotfix." Kind of like search & replace, but that function can't delete cells that contain certain text. Thanks for any help! If you mean Delete the CONTENTS of the cell, then you can use Find and Replace with wild cards: Edit/Replace Find what: *hotfix* Replace with: <leave blank <Replace All If you actually want to <delete the cell, you'll have to use a VBA routine and also decide which way to move the remaining cells. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete rows containing specific data | New Users to Excel | |||
| Specific keywords copying data to cells | Excel Worksheet Functions | |||
| how to delete contents of cells having specific data | Excel Discussion (Misc queries) | |||
| Locate and delete specific cells | Excel Discussion (Misc queries) | |||
| How do I take data entries and assign them to specific cells that. | Excel Discussion (Misc queries) | |||
Linear Mode
