First(dot)Last + @email.com

[Jason Sands]

Greetings.
I searched for combining first and last names in excel + e-mail
address in the group and Google web, so please do not hate if this has
been answered.

I have column A, last name, and column B, first name.
I would like to create the email address in column F.
(e-mail address removed)
I got =B3&"."&A3 to work but could not get any further.

I can manually edit the users that do not have email, but anyone that
does not have a B (first name) field will not have an e-mail address.

THX
JHS

 

[Dave Peterson]

Maybe...

=if(counta(a3:b3)<2,"",b3&"."&a3&"@.company.com")

or maybe better:
=if(counta(a3:b3)<2,"",hyperlink("mailto:"&b3&"."&a3&"@.company.com"))
(A clickable hyperlink was created)

or
=if(counta(a3:b3)<2,"",
hyperlink("mailto:"&b3&"."&a3&"@.company.com","Click me"))

 

[Jason Sands]

Maybe...

=if(counta(a3:b3)<2,"",b3&"."&a3&"@.company.com")

or maybe better:
=if(counta(a3:b3)<2,"",hyperlink("mailto:"&b3&"."&a3&"@.company.com"))
(A clickable hyperlink was created)

or
=if(counta(a3:b3)<2,"",
hyperlink("mailto:"&b3&"."&a3&"@.company.com","Click me"))

=if(counta(a3:b3)<2,"",b3&"."&a3&"@company.com") worked excellent! I
had to take . out after @ and before company.com. Thank you very much,
sir.

 

[Dave Peterson]

Stupid fingers made a typo!!

Glad you got it working.

(You didn't like the =hyperlink() version???)

 

[Jason Sands]

The hyperlink part worked well and I may use it in the future, but I
used your formula to make a .csv to load on various cell phones. Cell
phones could care less if there is a hyperlink.

 

[Dave Peterson]

Ahhh.

The hyperlink part worked well and I may use it in the future, but I
used your formula to make a .csv to load on various cell phones. Cell
phones could care less if there is a hyperlink.