Comma needed in CONCAT formula

[SaraWitch]

Hello peeps,

Probably a really easy one for someone, but I have a CONCAT formula and need a comma and space separating the two cell values, i.e., I want the top address to show as "The Grand Cave, Flat 100, Cloud Avenue, East Sun, MA6 1CK"

¦ MrExcel Queries.xlsm
	A	B	C
1	The Grand Cave	Flat 100, Cloud Avenue, East Sun, MA6 1CK	The Grand CaveFlat 100, Cloud Avenue, East Sun, MA6 1CK
2		Room 11, Witching Way, Hatstone, HA6 6RD	Room 11, Witching Way, Hatstone, HA6 6RD
CONCAT

Cell Formulas
Range	Formula
C1:C2	C1	=CONCAT(IF(ISBLANK(A1),"",A1),B1)

I've tried some variations but can't get it to work. Any help would be appreciated

 

[dreid1011]

Maybe:

=IF(A1="","",A1&", ")&B1

Book1
	A	B	C
1	Yellow	Green, Blue, Red	Yellow, Green, Blue, Red
2		Green, Blue, Red	Green, Blue, Red
Sheet2

Cell Formulas
Range	Formula
C1:C2	C1	=IF(A1="","",A1&", ")&B1

 

[SaraWitch]

That works perfectly! Thank you, @dreid1011!

 

[Scott Huish]

You have Excel 365, so perhaps:
=TEXTJOIN(", ",TRUE,A1:B1)

 

[dreid1011]

That works perfectly! Thank you, @dreid1011!

You're welcome, and happy to help.

 

[SaraWitch]

That works too - thank you, @Scott Huish!