How to filter only mail id in excel

To filter only email addresses 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 "Text" as the filter type.
5. In the "Filter" field, enter the following formula: =FILTER(A1:A10, ISEMAIL(A1:A10))
   • Replace A1:A10 with the range of cells that contains the email addresses.
   • The ISEMAIL function checks if the value in each cell is a valid email address.
6. Click "OK" to apply the filter.

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 column header of the column that contains the email addresses.
5. Select "Text Filters" > "Contains" > "Email Address"
6. In the "Filter" dialog box, enter the following formula: @*
   • The @* syntax matches any email address.
7. Click "OK" to apply the filter.

Tips:

• Make sure to select the correct column that contains the email addresses.
• If you want to filter only email addresses that contain a specific domain (e.g., @gmail.com), you can modify the FILTER formula or the AutoFilter criteria to include the domain.
• You can also use regular expressions (regex) to filter email addresses. For example, you can use the REGEX function to filter email addresses that match a specific pattern.