ConcantenatingTwo Labels into One
 

I have a spreadsheet with 3 column: First Name, Last Name
and Full Name.
Is there some type of formula I can put into the Full Name
cell that will concantenate the values in the Last and
First Name cols such as this: "Last Name, First Name"?

Thank you

Sure -

=B1&", "&A1

i.e. =lastname&", "&firstname

You can also use the concatenate worksheet function,

=CONCATENATE(B1,", ",A1)



"Bob" wrote in message
...
I have a spreadsheet with 3 column: First Name, Last Name
and Full Name.
Is there some type of formula I can put into the Full Name
cell that will concantenate the values in the Last and
First Name cols such as this: "Last Name, First Name"?

Thank you

Bob

In C1 enter =B1 & ", " & A1

Will return LastName, FirstName

Gord Dibben Excel MVP

On Mon, 20 Dec 2004 13:14:55 -0800, "Bob"
wrote:

I have a spreadsheet with 3 column: First Name, Last Name
and Full Name.
Is there some type of formula I can put into the Full Name
cell that will concantenate the values in the Last and
First Name cols such as this: "Last Name, First Name"?

Thank you

Hi,
=CONCATENATE(A1,", ",B1)

"Bob" wrote:

I have a spreadsheet with 3 column: First Name, Last Name
and Full Name.
Is there some type of formula I can put into the Full Name
cell that will concantenate the values in the Last and
First Name cols such as this: "Last Name, First Name"?

Thank you

Hi
=A1 & " " & B1

--
Regards
Frank Kabel
Frankfurt, Germany
"Bob" schrieb im Newsbeitrag
...
I have a spreadsheet with 3 column: First Name, Last Name
and Full Name.
Is there some type of formula I can put into the Full Name
cell that will concantenate the values in the Last and
First Name cols such as this: "Last Name, First Name"?

Thank you

Try =A1 & " " & B1 -- assuming first name is in A1 and last name is in B1.

Art

"Bob" wrote:

I have a spreadsheet with 3 column: First Name, Last Name
and Full Name.
Is there some type of formula I can put into the Full Name
cell that will concantenate the values in the Last and
First Name cols such as this: "Last Name, First Name"?

Thank you

Bob,

You can either use the Concatenate function or you can use the shortcut.

Assume First name is in A1 and Last name is in B1.

Concatenate function
=============

=CONCATENATE(B1,", ",A1)

Shortcut
======

=B1&", "&A1

Either one will generate you the same result.

I hope this helps.

Sincerly,
Rekoj

"Bob" wrote:

I have a spreadsheet with 3 column: First Name, Last Name
and Full Name.
Is there some type of formula I can put into the Full Name
cell that will concantenate the values in the Last and
First Name cols such as this: "Last Name, First Name"?

Thank you

Bob -

A2 - John, B2=Jones, C2 = Full Name

in C2 enter =A2&" "&B2

HTH,
Carole O

"Bob" wrote:

I have a spreadsheet with 3 column: First Name, Last Name
and Full Name.
Is there some type of formula I can put into the Full Name
cell that will concantenate the values in the Last and
First Name cols such as this: "Last Name, First Name"?

Thank you