How To Copy Domain Names From Email Addresses In One Column In An Excel File To Another Column?

July 28th, 2009 by Cheap Web Hosting Leave a reply »

There are hundreds of email addresses in a column in an Excel file. How to copy domain parts(the right part of @, say “yahoo.com” if an email address is xxx@yahoo.com)these emails to another column? Any tips? I don’t want to copy and paste them one by one.

Posted in Domain Names

Tags:

You can follow any responses to this entry through the RSS 2.0 Feed. You can leave a response , or trackback from your own site.

Advertisement

1 comment

Add your comment
  1. hosting says:
    July 28, 2009 at 3:43 pm

    Select the entire colomn, click DATA, then TEXT TO COLOMNS, select DELIMITED and click NEXT. Tick OTHER and type @ then NEXT and FINISH

Leave a Reply

You must be logged in to post a comment.