how do i delete rows that end in SMPT

W

willie

i am trying to clean up my excel data base. I want to delete all rows tha end
in SMPT. How can i set up the Column to do this easily instead of one by one.
 
J

Jaleel

Hi

Select the column. Go to Data – Filter – AutoFilter. Click the arrow and
select (Custom). Click the left arrow under “Show rows were†and select
"ends with". Now click the right arrow and type SMPT. Click OK.

Select all the rows by clicking the gray number part and go to Edit – Go To
– Special – Select visible cells only. Go to Edit – Delete Rows. Clear the
AutoFilter arrow by clicking Data – Filter – AutoFilter again.

Regards,

Jaleel
 
Top