How to combine multiple cells in excel

How to combine the values of multiple cells in excel

0
1990
How to combined different cells in excel

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

How to combine multiple cells in excel

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

How to combine two cells in excel with a comma between

 

=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

How to combine multiple cells in excel

=A2&” “&B2&” “&C3

Don’t forget, you can add commas etc. between multiple cells also

Tools you'll need

LEAVE A REPLY

Please enter your comment!
Please enter your name here