ConcantenatingTwo Labels into One

B

Bob

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
 
D

Dave R.

Sure -

=B1&", "&A1

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

You can also use the concatenate worksheet function,

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

Gord Dibben

Bob

In C1 enter =B1 & ", " & A1

Will return LastName, FirstName

Gord Dibben Excel MVP
 
R

Rekoj

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
 
Top