Join the Text From Two or More Cells Into One Cell in Excel!!
Tags: excel, excelpreface, excelbasics, exceltutorials
Published: 2021-01-22 12:06:21

---
title: Join the Text From Two or More Cells Into One Cell in Excel!!
published: true
date: 2021-01-22 12:04:07 UTC
tags: Excel,ExcelPreface,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/join-text-from-two-or-more-cells-into-one-cell-excel/
---

Sometimes you need to join the values from the different cells and return to a single cell with commas, the space character, or any other delimiter. Here is the tutorial to achieve this job. Let’s see **how to join the text from two or more cells into one cell in Excel**. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Steps to join the text from two or more cells:

You can merge the text from two or more cells into one cell from the following methods.

### Method 1:

- To combine cells from a range to a cell with commas, just use the concatenation operator shown below.

**=A1&”, “&B1&”, “&C1**

- **CONCATENATE** – It helps to join two or more text strings together and returns the result into one string. Read more on the [**CONCATENATE**  **function**](https://geekexcel.com/how-to-use-concatenate-function-in-microsoft-excel-365/).

### Example:

- Let’s see the below example image here we will show how to join the text using a comma symbol.

![Concatenation operator](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Concate-function.png)<figcaption id="caption-attachment-21376">Concatenation operator</figcaption>

### Method 2:

If some values in the cells are empty means, you can use the below formula to join the text.

**=[SUBSTITUTE](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/)([TRIM](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/)(A1&” “&B1&” “&C1))**

### Argument Explanations:

- [**SUBSTITUTE**](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/) – It will replace existing text with new text in a text string when you want to replace text based on its content, not position.
- [**TRIM**](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/) – This function helps to remove the extra spaces from the text and there is no space at the start or end of the text string.

### Practical Example:

- Let’s see how to join the text from the cells where the cells contain empty space.
- Refer to the below example image. Here, you will see that there are multiple empty strings between words.

![Input data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-data.png)<figcaption id="caption-attachment-21377">Input data</figcaption>

- Apply the given formula, where you want to display the result.

![Apply formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Apply-formula.png)<figcaption id="caption-attachment-21378">Apply formula</figcaption>

- It will remove the empty strings from the text and just leaves one comma between all words as per the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-42.png)<figcaption id="caption-attachment-21379">Result</figcaption>

## Verdict:

Hope you understood how to **join the text from two or more cells and return to one cell in Excel Office 365**. Please state your **queries** in the below **comment** section. Thank you so much for visiting **[Geek Excel](https://geekexcel.com/)!!**

### Read Ahead:

- **[Combine Text from Two or More Cells into One Cell in Excel 365!!](https://geekexcel.com/combine-text-from-two-or-more-cells-into-one-cell-in-excel-365/)**
- **[Excel Formulas to Find Multiple Matching Values in Comma-Separated List](https://geekexcel.com/excel-formulas-return-multiple-matching-values-comma-separated-list/)**