Separate the Components of Email Address

MsCutler

New Member
Joined
Oct 13, 2006
Messages
2
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.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
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

New Member
Joined
Oct 13, 2006
Messages
2
Dominic:

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

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Hi MsCutler

You're welcome.

Code:
Have a good evening.
I already have thank you. Local time is five past midnight, and I'm going to bed! :)

DominicB
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,622
Office Version
  1. 365
Platform
  1. Windows
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
 

Forum statistics

Threads
1,141,417
Messages
5,706,311
Members
421,441
Latest member
VapesRub

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top