View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patrick Patrick is offline
external usenet poster
 
Posts: 160
Default How can I combine cells with first/last names into email addy?

Yes, I got that far, but I want Excel to hyperlink it automatically to create
a "clickable" email address.

"Gary''s Student" wrote:

if the names are in A1 and B1, use:

=A1 & "." & B1 & "
--
Gary's Student


"Patrick" wrote:

I need to combine a first name with last name, combine them with a domain to
create a useable email address.