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

Posted on October 16, 2009 by admin

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.

This entry was posted in Good Domain Names and tagged , , , , , , , , , . Bookmark the permalink.

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

  1. JJ says:
    October 16, 2009 at 11:04 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

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>