Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 5 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .