Hi - Dave here.
Happy Friday!
In my last email, we looked at how to
create an email address from a name and domain using concatenation.
In this email, I want to show you how to get the domain from an email address, as seen in the workbook below. The formula in E5, copied down, is:
=TEXTAFTER(C5,"@")
[
Download the workbook and read the full explanation]
This is an easy problem in the current version of Excel, which offers the TEXTAFTER and TEXTSPLIT functions. In older versions of Excel, you can use a formula based on the RIGHT, LEN, and FIND functions. The attached worksheet contains formulas for all three options. Click the link above to read the full explanation and download the workbook.
Excel formulas
We maintain a list of over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
