| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows that DO NOT contain certain text
Hi. I have a file that has several sheets, and each sheet is about
40k rows long. It was an import from a text file. In column B is a long text string. I need to delete all rows in every sheet that DO NOT contain the word "logoff" OR "timeout" OR "logon" somewhere in the cell in column B. I am basically trying to delete the stuff I don't need so the file is more manageable and can be worked with. Thanks in advance for your help! Steph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows with specific text | New Users to Excel | |||
| find text and delete rows. | Excel Discussion (Misc queries) | |||
| Delete rows with certain text | Excel Worksheet Functions | |||
| easy way to delete all rows with no text in them? | New Users to Excel | |||
| delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
![Steph[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
