Combining text from different cells is made easy with the CONCATENATE function or the & operator.

To merge the contents of cells A1 and B1, you could use =CONCATENATE(A1, ” “, B1) or simply =A1 & ” ” & B1.

Getting Started with Google Sheets image 15