CONCATENATE combines text from multiple cells into one. For example, =CONCATENATE(A1, " ", B1) merges the contents of A1 and B1 with a space in between. The modern equivalent is =A1 & " " & B1.