FIND(“@”,Email) will return the location of the “@” character in the email address. In our example FIND(“@”,”jim.smith@breadmakers.com”) returns 10 since the “@” symbol is the 10th character in the email address. The difference between these two will then give us the total character count of all the characters after the “@” symbol. This is the total character count of the domain (let’s call this N). In our example this is 25-10 = 15. We see that “breadmakers.com” does in fact have 15 characters in it. We can now use RIGHT(Email,DomainCount) to extract the N right most characters from the email address which will be our domain. In our example this is RIGHT(“jim.smith@breadmakers.com”,15) which returns “breadmakers.com”.
