Thread: [Solved] Concatenate with @ symbol
View Single Post
 
Old 02-06-2015, 09:31 AM
anickles anickles is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2015
Posts: 3
anickles is on a distinguished road
Default Concatenate with @ symbol

Hi,

I have three columns of data. First Name, Last Name, Domain Name

I want to combine these three columns together using a formula. The problem I'm having is that the third column (domain name) includes this text:

@visdtx.org

I need to be able to concatenate or combine all three cells of data together and I also need to be able to add a period between the first name and last name so that I end up with an example result like:

John.Doe@visdtx.org
Reply With Quote