Select the cell where you want the combined text to appear
Type =CONCATENATE(text1, text2, …)
Replace text1, text2, etc. with cell references or text in quotes
Separate each argument with commas
Use quotation marks for spaces or punctuation, such as ” “
Press Enter to combine the text
Example: =CONCATENATE(A1, ” “, B1)
Use the ampersand operator as an alternative: =A1&” “&B1
Copy the formula down to apply it to other rows
Use CONCAT instead of CONCATENATE in newer Excel versions
Use TEXTJOIN if you need a delimiter between multiple cells