Creating Mailing List From Excel
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
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