How to filter only mail in excel

To filter only emails in Excel, you can use the FILTER function or the AutoFilter feature. Here are the steps:

Method 1: Using the FILTER function

1. Select the range of cells that contains the email addresses.
2. Go to the "Formulas" tab in the ribbon.
3. Click on the "Filter" button in the "Function Library" group.
4. In the "Filter" dialog box, select "Email" as the filter type.
5. Click "OK" to apply the filter.

The FILTER function will only show the rows that contain email addresses.

Method 2: Using AutoFilter

1. Select the range of cells that contains the email addresses.
2. Go to the "Data" tab in the ribbon.
3. Click on the "Filter" button in the "Data Tools" group.
4. Click on the dropdown arrow in the header row of the column that contains the email addresses.
5. Select "Text Filters" > "Contains" > "Email".
6. Enter the email address you want to filter by (e.g. "@example.com").
7. Click "OK" to apply the filter.

The AutoFilter feature will only show the rows that contain email addresses that match the filter criteria.

Tips:

• Make sure to select the correct column that contains the email addresses.
• If you want to filter multiple email addresses, separate them with commas (e.g. "@example.com, @example.net").
• You can also use the FILTERXML function to filter email addresses, but this method is more complex and requires a specific syntax.