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