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

Filed under: email list mailing — admin @ 10:31 pm

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

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&"."&B1&"@"&"puppies.com"

Then copy formula down

powered by Yahoo Answers

1 Comment »

  1. 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&"."&B1&"@"&"puppies.com"

    Then copy formula down
    References :

    Comment by brayden — August 27, 2009 @ 3:52 am

RSS feed for comments on this post. TrackBack URL

Leave a comment