Separate the Components of Email Address

[MsCutler]

I have a list of email addresses that I need to separate the domain name from the person's name and place the domain name in another column. I am new to Excel and found the following formula on a message board, but it only performs my desired goal on the first cell and not the entire column. That formula was =right(a1,len(a1)-find("@",a1). I am not sure what all of this means and the Help section in Excel really didn't help me much in understanding it.

There are 649 email addresses in column A and I want the domain names from each address to go into column B (next to the existing email address).

Can someone help me please? Thank you very much.

 

[DominicB]

Good evening MsCutler

Welcome to the board!

The formula is pretty much good to go - slight typo in that you missed off closing your brackets, the full formula would be :

=RIGHT(A1,LEN(A1)-FIND("@",A1))

Say A1 contains dominicb@domski.co.uk, then that formula in cell B1 would return domski.co.uk. Is this not what you want? You then just copy this formula all the way to the bottom of your list.

HTH

DominicB

 

[MsCutler]

Dominic:

Thank you for the welcome and most of all for helping with the formula! It worked perfectly. Have a good evening.

 

[DominicB]

Hi MsCutler

You're welcome.

Have a good evening.

I already have thank you. Local time is five past midnight, and I'm going to bed!

DominicB

 

[Peter_SSs]

MsCutler

Welcome to the Mr Excel board!

Sounds like you have achieved what you want, but here is another way that might be useful for you to know.

1. Select column A by clicking its heading label.
2. Copy
3. Select column B by clicking its heading label.
4. Paste
5. While column B is still selected Edit|Replace...|Find what: *@|Replace with: leave blank|Replace All