concatenate and add period simultaneously

[ywmpp]

Hi, I'm trying to create an e-mail address using first and last name columns. Can I concatenate and add period in same formula?

Appreciate your help.

 

[Jonmo1]

Sure, someting like

=A1&"."&B1&"@yahoo.com"

 

[mikerickson]

Can you post a sample of your data lay-out.

Yes, you can concatenate this kind of thing

="Last" & "First" & "@email" & "." & "com"