Adding a comma and a space to a column of names

[KuraiChikara]

Hello, I have a list of names that I will be using the CONCATENATE function on. However, they have to be in a particular format.

Example:
Column A1 has LAST NAMES
Column B1 has FIRST NAMES

Column A already has all of the Last Names IE "Doe" in A1.
What it needs to look like is Doe, (Doe comma/space)

However, the entire column of names has hundreds of names that need the comma and the space added and I do not know how to do that. I tried:
=A1,

But it does not work.

Is there a way to add a comma and a space using a formula to the last names? From there I can simply paste the values of that then add my CONCATENATE formula.

 

[Scott T]

Book1
	A	B	C	D
1	Doe	John	Doe,	Doe, John
Sheet1

Cell Formulas
Range	Formula
C1	=A1&", "
D1	=A1&", "&B1

 

[KuraiChikara]

Note: I can amend the comma, I just cant figure out the space. I've used =A1&"," which will give me Doe, but not Doe, (space). Because when I concatenate I want Doe, John not Doe,John.

 

[KuraiChikara]

Awesome thank you, I knew how to amend the comma but not get the space, putting a space before the next quote is what I didnt do. Thank you.

 

[Scott T]

You're welcome