Formula to join two cells with a dot in between?

Mr2017

Well-known Member
Joined
Nov 28, 2016
Messages
634
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi

I have a list of names where I'd like to combine the First Name and Surname (but have a dot in between them), then add a corporation at the end of each name so that their email address is created automatically!

I'm sure this is possible, but I can't remember how to do it!

Please find below some sample data.

Cells A1 and A2 have the names John Smith and Jane Doe, respectively.

B1 and B2 have lower case versions of the data in cells A1 and A2, using the =lower(A1) and =lower(A2) formulas, respectively.

C1 and C2 are cells where I'd like to return the e-mail addresses.

And D1 and D2 have the '@' sign and the corporation that I'd like to add to the end of the names.

Does anyone know how to do this, please? I can add the corporation name myself. It's the joining of the names (which will vary in length eg Johnny Smith instead of John Smith) that I can't remember the formula for!

John Smithjohn smith@microsoft.com
Jane Doejane doe@microsoft.com
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
1,031
Office Version
  1. 365
  2. 2007
Platform
  1. Windows

Mr2017

Well-known Member
Joined
Nov 28, 2016
Messages
634
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Awesome!

Thanks for the prompt response!

That worked - thank you!
 

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
1,031
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
You're welcome and thanks for the feedback.
 

Mr2017

Well-known Member
Joined
Nov 28, 2016
Messages
634
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
No problem.

Thank you!
 

Watch MrExcel Video

Forum statistics

Threads
1,113,755
Messages
5,544,000
Members
410,589
Latest member
MrBK
Top