# Get domain from email address

At the core, this formula extracts characters from the right with the RIGHT function, using FIND and LEN to figure out how many characters to extract. C4 contains the text "achang@maaker.com", so LEN returns 17 characters:

LEN(C4) // returns 17

FIND locates the "@" character inside the email address "achang@maaker.com". The "@" character is the 7th character, so FIND returns 7:

FIND("@",C4) // returns 7

The number 7 is then subtracted from the 17, which is 10. The number 10 is used as the second argument for the RIGHT function, which extracts 10 characters from the email address, starting from the right. The complete formula is evaluated and solved like this:

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

## Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.