Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Forgive the ASCII art (art!$?) but how do I get the stuff from C1 & C2 into C3 with some additional text.

--------|-------|------------------|
C1      |  C2   |   C3             |
-----------------------------------|
John    |  Doe  |   First Name: C1 |
        |       |   Last  Name: C2 |
-----------------------------------|
share|improve this question
    
BTW how do I handle the new line between First Name and Last Name. "\n Doesn't Work!" –  Holysmoke Sep 14 '09 at 10:05
    
Just use Char(10) as the newline character ans make sure you have Wrap text enabled for the cell you use the formula in, otherwise you'll only see a square. –  alex Sep 14 '09 at 10:30

3 Answers 3

up vote 4 down vote accepted

Just use the concatenate function. You could use something like

= CONCATENATE("First name: "; C1; CHAR(10); "Last name: "; C2)

Edit: I added CHAR(10) to the formula to create a newline between the 2 fields. However, you have to enable Wrap text for the cell.

share|improve this answer
    
I tested this in Excel 2003 and the semi-colon was correct. Trying it out in Excel 2007 works only with using a comma, as you said. This seems odd. Snark also used a semi-colon... –  alex Nov 6 '09 at 10:04
    
For Excel 2007 your syntax is wrong - it should be , (comma) rather than ; (semi-colon) –  ChrisF Nov 6 '09 at 10:13
    
Odd that they should change this between the 2003 & 2007 versions. –  ChrisF Nov 6 '09 at 10:14
    
@ChrisF : difference in the handling of Regional Settings in Excel between the 2003 and 2007 versions? I'm using French settings. –  Snark Feb 28 '10 at 22:41
    
@Snark could be... I had English at work and Romanian settings at home. It might be an explanation for the difference. –  alex Mar 1 '10 at 6:27

It's in your subject: concatenate! :-)

In C3, use the formula:

=concatenate("First Name: ";C1;" Last Name: ";C2)
share|improve this answer

This is what I would use:

="First Name: " & C1 & " Last Name: " & C2
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.