Forum Discussion
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, ...
You can try different ways.
=B2&"."&D2&"@noemail.com"=CONCAT(B2,".",D2,"@noemail.com")=TEXTJOIN(".",TRUE,B2,D2,"@noemail.com")
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.
