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

**fireworkboi** · 02-16-2009, 07:01 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

**martindwilson** · 02-16-2009, 07:31 PM

in third column
a1&"."&b1&"@puppies.com"

**shg** · 02-16-2009, 08:32 PM

If you want a clickable hyperlink, then

=HYPERLINK("mailto:" & A1 & "." & B1 & "@puppies.com", A1 & " " & B1)

or,

=HYPERLINK("mailto:" & A1 & "." & B1 & "@puppies.com", A1 & "." & B1 & "@puppies.com")