## 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