Email Domain Excel Formula

In the above formula 255 is just a large number to make sure you get the whole domain.

Email domain excel formula. Right email len email find email summary t extract the domain from an email address you can use a formula based on the right len and find functions. Changing the value in the named range will then update all email addresses at once. To simply the formula you could create a named range domain to hold the domain name then rewrite the formula like this.

With a named range. Open your worksheet and type this formula mid b2 find b2 1 1 255 into a blank cell beside your email address in this example i will enter this formula into cell c1 b2 contains the email address that you want to use see screenshot. In a blank cell c1 enter this formula mid a1 search a1 1 255 see screenshot.

Using this mixed mid and search function you can quickly get the domain names from the list please do as this. Lower left first last domain. Extract domains from email addresses with function.