Forum Discussion
Mary_W995
Oct 12, 2021Copper Contributor
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
- Juliano-PetrukioBronze Contributor
You can try different ways.
=B2&"."&D2&"@noemail.com"=CONCAT(B2,".",D2,"@noemail.com")=TEXTJOIN(".",TRUE,B2,D2,"@noemail.com")- Mary_W995Copper ContributorThank you so much!!! I thought I tried that configuration, but this works. I really appreciate your help!
- Juliano-PetrukioBronze ContributorAnytime my friend.
Remember to flag it as solved and hit the like button.