How to filter text using wildcard characters in Excel tables

How to filter text using wildcard characters in Excel tables

1, start Excel 2013 and open the worksheet, select the range of data you want to filter, and then click the Filter button in the Sort and filter group on the Data tab to enter the AutoFilter status. Click the Lower triangle button to the right of the Name column heading, select the text filter option in the Open Drop-down list, and then select the Custom Filter option in the cascading list, as shown in Figure 1.

Figure 1 Selecting the Custom filter option

2. Open the Customize AutoFilter dialog box, select the Equals option in the first Drop-down list box in the Name column, and enter the text "King *" in the second Drop-down list box, as shown in Figure 2.

Figure 2 The Customize AutoFilter dialog box

Attention

The wildcard character "?" is given in the Customize AutoFilter dialog box. And the Meaning of "*", if you want to filter the data, you need to get the inclusion "?" or "*" data, just in the "?" or "*" before adding "~" can be.

3. When you click OK to close the Customize AutoFilter dialog box, the results of the filter are displayed in the worksheet, which is the information for all students whose names are named "Wang", as shown in Figure 3.

Figure 3 shows the filter results

Attention

Click the Lower triangle button to the right of the Name column heading and select the text filter option in the Open Drop-down list. Then in the cascading list, select the "Start yes" option, and also open the Custom AutoFilter dialog box, where you can filter the instance by simply entering the last name, without having to enter a wildcard character.