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.

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

"willie" wrote:

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.