You can use the following formulas to combine values from two columns in Excel with a space in between them:
Formula 1: Use & Symbol
=A2&" "&B2
Formula 2: Use CONCAT Function
=CONCAT(A2, " ",B2)
Formula 3: Use TEXTJOIN Function
=TEXTJOIN(" ", TRUE, A2:B2)
Each of these formulas combines the values from cells A2 and B2 into a single cell with a space in between the values.
The following examples show how to use each formula in practice with the following two columns in Excel that contain information about various basketball players:
Let’s jump in!
Example 1: Use & Symbol
We can type the following formula into cell C2 to combine the value in cell A2 with the value in cell B2 with a space in between the values:
=A2&" "&B2
We can then click and drag this formula down to each remaining cell in column C:
Column C combines the values from columns A and B into a single cell with a space in between the values.
Example 2: Use CONCAT Function
We can type the following formula into cell C2 to combine the value in cell A2 with the value in cell B2 with a space in between the values:
=CONCAT(A2, " ",B2)
We can then click and drag this formula down to each remaining cell in column C:
Column C combines the values from columns A and B into a single cell with a space in between the values.
Note: You can find the complete documentation for the CONCAT function in Excel here.
Example 3: Use TEXTJOIN Function
We can type the following formula into cell C2 to combine the value in cell A2 with the value in cell B2 with a space in between the values:
=TEXTJOIN(" ", TRUE, A2:B2)
We can then click and drag this formula down to each remaining cell in column C:
Column C combines the values from columns A and B into a single cell with a space in between the values.
Note: You can find the complete documentation for the TEXTJOIN function in Excel here.
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
Excel: How to Remove Specific Text from Cells
Excel: How to Delete Rows with Specific Text
Excel: How to Check if Cell Contains Partial Text
Excel: How to Check if Cell Contains Text from List
