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,422
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Like this?

Code:
=A1&"."&B1&C1
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 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
Concatenate with @ symbol Concatenate function for displaying numbers in words officeboy09 Excel 12 10-30-2013 08:08 PM
If, move and concatenate in VBA devcon Excel Programming 0 07-04-2011 12:44 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:27 AM.


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