How can I copy text from multiple cells into one automatically in Excel?

Answer 1

Assume you want to concatenate the text from a1, a2, a3, and a4 into b1.

In b1, type the following: “=a1&a2&a3&a4”