Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #16  
Old 12-27-2017, 10:30 PM
ewso ewso is offline delete rows not containing certain text Windows 10 delete rows not containing certain text Office 2016
Advanced Beginner
delete rows not containing certain text
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default


All I now have is a blank worksheet. If I have a worksheet with 100 rows and 20 of the rows have the word "coffee" in them, and 20 other rows have the word "cups" in them, I need to delete only the 60 rows that don't have either word in them. If a row has either word, I need to keep it.
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
delete rows not containing certain text Macro to delete rows not containing specific text Alimou Excel Programming 4 02-06-2017 07:35 AM
delete rows not containing certain text Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
delete rows not containing certain text Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM
delete rows not containing certain text Delete Blank Rows (Cyrillic Text in Spreadsheet ) dozd Excel 1 02-22-2013 03:24 AM
delete rows not containing certain text Delete all rows but the last. elky1967 Word VBA 14 09-21-2012 05:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft