#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
It worked perfectly. Thank you very much!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Concatenate function for displaying numbers in words | officeboy09 | Excel | 13 | 08-09-2021 12:59 PM |
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 |
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 |