MS Excel , Search and Remove All text Matching a pattern

0
17

 

Suppose we have an excel file with a good amount of data and we need to find lines matching a pattern or remove some lines obey a pattern. Doing this manual will be tedious, here is the steps to do in a breeze

first open your excel file

select the column or columns you need to filter

Now go to Menu Data >> Filter >> Auto filter

Image

 

from the drop down option ( see picture)

select (custom …) here is the window

Image

 

Now select your criteria here and press ok , result will be

 

Image

if you want to remove these rows simply click Delete while selecting the entire rows

To go back click on the dropdown box and select All on top

Image

you ll be back to All Records

LEAVE A REPLY

Please enter your comment!
Please enter your name here