Concatenate strings from different cells into 1 cell

Question

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 |
-----------------------------------|

Answer 1

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.

Answer 2

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

In C3, use the formula:

=concatenate("First Name: ";C1;" Last Name: ";C2)

Answer 3

This is what I would use:

="First Name: " & C1 & " Last Name: " & C2