Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2015, 09:31 AM
anickles anickles is offline Concatenate with @ symbol Windows 7 64bit Concatenate with @ symbol Office 2007
Novice
Concatenate with @ symbol
 
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
  #2  
Old 02-06-2015, 09:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Concatenate with @ symbol Windows 7 64bit Concatenate with @ symbol Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,770
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Like this?

Code:
=A1&"."&B1&C1
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 02-06-2015, 09:39 AM
anickles anickles is offline Concatenate with @ symbol Windows 7 64bit Concatenate with @ symbol Office 2007
Novice
Concatenate with @ symbol
 
Join Date: Feb 2015
Posts: 3
anickles is on a distinguished road
Default

It worked perfectly. Thank you very much!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate with @ symbol Concatenate function for displaying numbers in words officeboy09 Excel 13 08-09-2021 12:59 PM
Concatenate with @ symbol Concatenate if in descending order pgeorgilas Excel Programming 2 12-10-2014 01:35 AM
Concatenate two textbox values for message box Smithy02468 Excel Programming 1 11-08-2014 10:48 PM
Concatenate with @ symbol how to find and replace a symbol with another symbol wondermuse Word 5 10-09-2014 06:30 AM
If, move and concatenate in VBA devcon Excel Programming 0 07-04-2011 12:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft