To get domain from email address in Microsoft Excel, use Excel functions, the Text to Column feature, or the Flash Fill feature.

If you have a list of email addresses in an Excel spreadsheet, you can import this into a Mac Address Book by converting the Excel file into a text-based Comma Separated Value file. Address Book ...