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