| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I get the domain name out a email adress?
Hello
I want to make a survey about which domain name is the most used. So I have a list of email addresses in Excel. But I want just the domain names of the email addresses. Then I will make a PivotTable so I can see every domain name and their amount! Now my problem is, how can I get the domain names out of the email addresses? Is it possible there is any function in Excel? Can someone help me please? |
|
#2
|
|||
|
|||
|
If they are all formatted like regular email addresses, i.e.
", you can select the range and go to Data-Text to Columns-Choose Delimited-Hit next, select "Other" and type an @ symbol for the delimiter. -- Regards, Dave "Gauthier" wrote: Hello I want to make a survey about which domain name is the most used. So I have a list of email addresses in Excel. But I want just the domain names of the email addresses. Then I will make a PivotTable so I can see every domain name and their amount! Now my problem is, how can I get the domain names out of the email addresses? Is it possible there is any function in Excel? Can someone help me please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Email Macro with Outlook Express | Excel Discussion (Misc queries) | |||
| Move a Column of 500 Email Addresses into BCC Field of an Email | Excel Worksheet Functions | |||
| body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
| Help me Please!! Need hyperlinks to show actual email address! | New Users to Excel | |||
| How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) | |||
Linear Mode
