CONCATENATE function giving a VALUE error EXCEL 2013

Question

Since Excel 2013 doesn't yet support the =CONCAT() fn, I was experimenting with the =CONCATENATE() fn instead. It worked perfectly when I added a "," between the two cells. However, it gave the #VALUE error when I attempted to input it as a range (=CONCATENATE(A1:B1)). Any suggestions on how I might approach this problem?

Answer 1

You can use the following:

=A1&","&B1

TEXTJOIN would also be helpful, but unfortunately not available in 2013.