The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

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

How to use wildcards with the XLOOKUP() function in Excel Your email has been sent Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions ...