Join two or more strings of text together with the CONCAT function. Type =CONCAT(A1, B1) to return "ABCD".