Click the cell where you want to put the combined text. Type “=(“.
Click the cell that contains the first text you want to combine (like a first name).
Type a space enclosed in quotation marks (“ “), and then click the next cell with the text that you want to combine (like a last name).
Type ) and then press enter.
To combine the text in more than two cells, continue selecting cells, and typing &” “& after each selected cell. If you don’t want to add a space between the combined text, type & instead of &” “&. To add a comma, type &”, “&.