jjkh58
New Member
- Joined
- Apr 21, 2021
- Messages
- 8
- Office Version
- 365
- 2013
- 2011
- 2010
- Platform
- Windows
- Mobile
- Web
Hi Guys,
Currently, I have a list of names i.e.
Christiano Ronaldo
John Doe
Tom Hanks
.
.
etc....
I am using this formula to concatenate the "@" and "my corporate email address"
(Note: I am getting the names from Table 9)
=Table9[@[Master List]]&"@"&"us.ms.com"&";"
Which gives the result like this Christiano Ronaldo@us.ms.com;
I would like this to be something like Christiano.Ronaldo@us.ms.com;
So pretty much adding "." in the middle of the name. What formula should I use to achieve this?. - I don't want to use the replace pop-up function to achieve this solution. It must be via formula. Thank you.
Currently, I have a list of names i.e.
Christiano Ronaldo
John Doe
Tom Hanks
.
.
etc....
I am using this formula to concatenate the "@" and "my corporate email address"
(Note: I am getting the names from Table 9)
=Table9[@[Master List]]&"@"&"us.ms.com"&";"
Which gives the result like this Christiano Ronaldo@us.ms.com;
I would like this to be something like Christiano.Ronaldo@us.ms.com;
So pretty much adding "." in the middle of the name. What formula should I use to achieve this?. - I don't want to use the replace pop-up function to achieve this solution. It must be via formula. Thank you.