Wednesday, October 21, 2009

How do I create a mailing list in excel from an email pattern?

If I have a list in excel (one column first names, next column last names) and they all have the same email pattern (first name, dot, last name@puppies.com, for example). Is there a way for excel to create in a third column a list of all those email addresses? Thanks a bunch
How do I create a mailing list in excel from an email pattern?
If first names are in column A and second names are in column B and you want them to be together with @puppies.com





=A1%26amp;"."%26amp;B1%26amp;"@"%26amp;"puppies.com"





Then copy formula down

No comments:

Post a Comment

 

email list Copyright 2008 All Rights Reserved Baby Blog Designed by Ipiet | Web Hosting