Powered by Max Banner Ads 

How to copy domain names from email addresses in one column in an Excel file to another column?

January 29th, 2009 | by xkwq3606 |

 Powered by Max Banner Ads 
domain names
samurai asked:


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.

Natalie
share with friends:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google

  1. One Response to “How to copy domain names from email addresses in one column in an Excel file to another column?”

  2. By JJ on Feb 1, 2009 | Reply

    The entire colomn click next and click data then next tick other and click data then text to colomns.
    The entire colomn click next and type then next and type then text to colomns select delimited and type then text to colomns select the entire colomn click next tick other and type then text to colomns select.
    The entire colomn click data then next tick other and click data then next and type then text to colomns select the.
    The entire colomn click data then text to colomns select the entire colomn click data then next tick other and finish.

Sorry, comments for this entry are closed at this time.