Oct 12 2021 12:35 PM
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!
Oct 12 2021 12:48 PM - edited Oct 12 2021 12:49 PM
SolutionYou can try different ways.
=B2&"."&D2&"@noemail.com"
=CONCAT(B2,".",D2,"@noemail.com")
=TEXTJOIN(".",TRUE,B2,D2,"@noemail.com")
Oct 12 2021 12:50 PM
Oct 12 2021 01:09 PM
Oct 12 2021 12:48 PM - edited Oct 12 2021 12:49 PM
SolutionYou can try different ways.
=B2&"."&D2&"@noemail.com"
=CONCAT(B2,".",D2,"@noemail.com")
=TEXTJOIN(".",TRUE,B2,D2,"@noemail.com")