How EXCEL Delete Unnecessary Information in Batch

Select the first line-Data-Filter-Auto Filter;

After filtering, select Custom from the A 1 column drop-down menu, select Exclude on the left, enter Shenzhen on the right, and then click OK;

At this point, all lines that do not contain the word Shenzhen will be displayed, while lines that contain Shenzhen will be hidden. Select these displayed lines and delete them. OK.