Forum Discussion

Mary_W995's avatar
Mary_W995
Copper Contributor
Oct 12, 2021
Solved

Formula help

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.lastmailto:name@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!

  • You can try different ways.

     

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

     

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

     

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

3 Replies

  • You can try different ways.

     

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

     

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

     

    =TEXTJOIN(".",TRUE,B2,D2,"@noemail.com")
    • Mary_W995's avatar
      Mary_W995
      Copper Contributor
      Thank you so much!!! I thought I tried that configuration, but this works. I really appreciate your help!
      • Juliano-Petrukio's avatar
        Juliano-Petrukio
        Bronze Contributor
        Anytime my friend.
        Remember to flag it as solved and hit the like button.