SOLVED

Formula help

Copper Contributor

Apologies in advance, I am sure this is very easy, but I can't figure it out. 

 

I have a spreadsheet with columns that include first name and last name.  I need pretend emails for all the people, and there can't be any duplicates.  So I'm trying to assign each person the email of firstname.lastname@noemail.com.

 

Here is what I have so far.  =B2&"."&D2  This works to give me first and last names separated by a dot.  What do I add to get @noemail.com after that?  I've tried everything I can think of and keep getting messages that it's not a good formula.  Thank you!

3 Replies
best response confirmed by Mary_W995 (Copper Contributor)
Solution

You can try different ways.

 

=B2&"."&D2&"@noemail.com"

 

=CONCAT(B2,".",D2,"@noemail.com")

 

=TEXTJOIN(".",TRUE,B2,D2,"@noemail.com")
Thank you so much!!! I thought I tried that configuration, but this works. I really appreciate your help!
Anytime my friend.
Remember to flag it as solved and hit the like button.
1 best response

Accepted Solutions
best response confirmed by Mary_W995 (Copper Contributor)
Solution

You can try different ways.

 

=B2&"."&D2&"@noemail.com"

 

=CONCAT(B2,".",D2,"@noemail.com")

 

=TEXTJOIN(".",TRUE,B2,D2,"@noemail.com")

View solution in original post