Dears, Is it Possible to Delete Rows ( Words) Which Contains 3 or More Successive Consonant or Vowels ? Example : AADBCAC → To be Deleted ( 3 Successive Consonants ) ABCUAFIP → To be Kept ABOAUST → To be Deleted ( 3 Successive Vowels) AZETUOP → To be Kept Thanks in Advance

Is it Possible to Delete Rows ( Words) Which Contains Successive Consonants or Vowels?

prasath17 (Guru) July 24, 2021, 1:49pm 9

@hsendel - I misread your requirement. Apologize…

Please check this…
FilterWords_Fixed.zip (83.0 KB)

1 Like

Forum Engagement Daily Reports

Topic		Replies	Views
Delete a specific sequence of words if exists Help	3	1097	January 21, 2019
Deleting rows in Excel (or datatable) that don't contain a certain word Help excel	13	1543	March 23, 2020
Deleting Rows if it does not contain certain keyword Help	5	1173	June 30, 2019
Delete Text to a certain word Help string	8	1574	October 20, 2019
Remove Excel Rows That Contain Keywords Help	10	4005	February 8, 2021