SOLVED

Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2839444%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839444%22%20slang%3D%22en-US%22%3E%3CP%3EApologies%20in%20advance%2C%20I%20am%20sure%20this%20is%20very%20easy%2C%20but%20I%20can't%20figure%20it%20out.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20columns%20that%20include%20first%20name%20and%20last%20name.%26nbsp%3B%20I%20need%20pretend%20emails%20for%20all%20the%20people%2C%20and%20there%20can't%20be%20any%20duplicates.%26nbsp%3B%20So%20I'm%20trying%20to%20assign%20each%20person%20the%20email%20of%20firstname.last%3CA%20href%3D%22mailto%3Aname%40noemail.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ename%40noemail.com%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20what%20I%20have%20so%20far.%26nbsp%3B%26nbsp%3B%3DB2%26amp%3B%22.%22%26amp%3BD2%26nbsp%3B%20This%20works%20to%20give%20me%20first%20and%20last%20names%20separated%20by%20a%20dot.%26nbsp%3B%20What%20do%20I%20add%20to%20get%20%40noemail.com%20after%20that%3F%26nbsp%3B%20I've%20tried%20everything%20I%20can%20think%20of%20and%20keep%20getting%20messages%20that%20it's%20not%20a%20good%20formula.%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2839444%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2839595%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839595%22%20slang%3D%22en-US%22%3EAnytime%20my%20friend.%3CBR%20%2F%3ERemember%20to%20flag%20it%20as%20solved%20and%20hit%20the%20like%20button.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2839499%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839499%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20try%20different%20ways.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DB2%26amp%3B%22.%22%26amp%3BD2%26amp%3B%22%40noemail.com%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DCONCAT(B2%2C%22.%22%2CD2%2C%22%40noemail.com%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DTEXTJOIN(%22.%22%2CTRUE%2CB2%2CD2%2C%22%40noemail.com%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2839522%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2839522%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much!!!%20I%20thought%20I%20tried%20that%20configuration%2C%20but%20this%20works.%20I%20really%20appreciate%20your%20help!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New 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 (New 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.