I have the following cell:
Marco Polo
and I would like to have a new cell with concatenating as follows an email:
[email protected]
This is the final email address I would like to have.
What is the concatenation syntax?
Thanks!
I have the following cell:
Marco Polo
and I would like to have a new cell with concatenating as follows an email:
[email protected]
This is the final email address I would like to have.
What is the concatenation syntax?
Thanks!
Try
=SUBSTITUTE(A1," ",".") & "@example.com"
Martin
My solution wont work as it does not take into consideration the . between the names.
Last edited by gmr4evr1; 02-15-2016 at 04:03 PM.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Formula:Please Login or Register to view this content.
v A B C 1 Name Domain 2 Marco Polo Yahoo.com [email protected]
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks