Looking for a formula to insert comma

[AUNTDEBBIE]

Is there a formula that I can use to insert a comma? I have a formula written to combine both first name and last name using concatenate. But I need it to seperate the 2 with a comma.

Thank you so much for your help.

AuntDebbie

 

[jeffreybrown]

How about...

=A1&", "&B1

A1 = Last Name
B1 = First Name

 

[f14]

Try =concatenate(LastName,", ",FirstName)

 

[AUNTDEBBIE]

Jeff, thank you so much!!! It worked perfectly.

 

[AUNTDEBBIE]

Thank you this worked exactly as I needed it to.