title: =CONCATENATE() function giving a #VALUE! error (EXCEL 2013)
body: <p>So I was trying out the =CONCATENATE() fn in Excel 2013, because apparently it doesn't yet support the =CONCAT() fn yet. When I put a &quot;,&quot; between the 2 cells, it ran just fine. But when I tried to input it as a range (=CONCATENATE(A1:B1)), it gave the #VALUE error. Any ideas as to how I can tackle this issue?</p>