Take the deleted text as an example, click the text filter, and then click Include in the secondary menu. Pop-up filter dialog box, enter the included text content, for example, click OK at the bottom after Chongqing. After the software is processed, the filtered result is what you want. Detailed steps:

1. Open Excel and click the column that contains the content to filter.

2. Then click the Start tab of the ribbon.

3. Enter the Start Options menu, find and click Sort and Filter.

4. Pop up the drop-down menu of sorting and filtering, and click Filter.

5. Go back to the data column and click the triangle mark behind the first row of cells.

6. The filter content menu will pop up. Take deleting the selected text as an example. Click the text filter, and then click Include Content in the secondary menu.

7. The filter dialog box pops up, where you can enter text content, such as Chongqing and click OK at the bottom.

8. After the software is processed, the filtered result is what you want. The above example only shows the cell contents including Chongqing, and that's it.