Combine two cells in excel with a space between.
You can easily combine two different cells in excel, all you need to do is enter the following into the formula bar:
=cell_one&” “&cell_two
Simply enter &” “& between the two cells you want to combine
Example
Below is a worked example of how to combine two cells with a space separating the values
As you can see
=cell_one&” “&cell_two
becomes =A2&” “&B2
Combine two cells in excel with a comma etc.
You can easily combine two different cells in excel, all you need to do is enter the following into the formula bar:
=cell_one&”, “&cell_two
Simply enter &”, “& between the two cells you want to combine. you can replace the comma with anything you like.
Example
=A2&”, “&B2
Combine more than two cells in excel.
You can easily combine more than two cells in excel, all you need to do is enter the following into the formula bar:
=cell_one&” “&cell_two&” “&cell_three
Ensure the first cell ends with &” Any middle cells start with “& and end with &” and that the end cell starts with “&
Example
=A2&” “&B2&” “&C3
Don’t forget, you can add commas etc. between multiple cells also
