Why use CONCATENATE vs & in Excel?

Question

I noticed that `"EXEC MySproc," & "arg, " & "arg2"` is essentially the same as `=CONCATENATE("EXEC MySproc,", "arg,", "arg2")` including the ability to use evaluations, functions etecetera. What is the usecase for using `=CONCATENATE()` vs `&`?

Answer 1

Good question. Most of the time, you’ll find them equally convenient.

A use case favoring the function CONCATENATE (or CONCAT in later Excels): if all your strings are in a range (such as A1:A25), then the formula =CONCATENATE(A1:A25)

is more convenient than =a1&a2&a3...