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 [email protected], for example). Is there a way for excel to create in a third column a list of all those email addresses? Thanks a bunch
in third column
a1&"."&b1&"@puppies.com"
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")
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks