How to combine text from two cells in Excel

When you're dealing with larger spreadsheets, you might need to create a table that pulls data from two different cells. This can be done quickly and easily in Microsoft Excel. If you're looking to combine text from two other cells, it's essential to know the correct formulas.

There are times when you need to combine text from two cells into one cell, especially if the data in your worksheet constantly changes. For example, you might need to combine different address fields for mailing labels or combine sales and marketing data into one field so you can create a PivotTable. The following methods will walk you through a simple way to accomplish this task.

Tips that are provided in this article are compatible with versions 2010/2013/2016.

How To Combine Text From Two Cells in Excel: TEXTJOIN Function?

Sometimes, you may need to combine text from two cells in Excel. The TEXTJOIN function is one of the most useful functions in Excel to combine text from multiple cells. In this article, we will discuss how to use the TEXTJOIN function to combine text from multiple cells.

The syntax of the TEXTJOIN function is as follows:

=TEXTJOIN(delimiter, first_text, second_text, third_text…)

The delimiter parameter is used to specify a character or string that separates the individual items of—a sequence. The first_text and second_text parameters are used to select the text or values that you want to merge together. The third_text parameter can be omitted if you just want to combine two strings using the same delimiter character or string.

1.Let’s try it on an example.

And that’s how we can combine text from two cells in Excel

How To Combine Text From Two Cells in Excel: Flash Fill Feature?

The Flash Fill feature is a very useful tool that can be used to combine text from two different cells.

If you need to combine text from two different cells, then the easiest way is to use the Flash Fill feature. Let us show you how it works:

1. Select the cell where you want to add the combined text and go to Data tab > Data Tools group > Flash Fill.

2 .In the Flash Fill dialog box that appears next, select “Blanks” as the main category and click OK button.

3 .Excel will now look for empty cells around your selected cell and fills them.

How To Combine Text From Two Cells in Excel: Concatenate Function?

The CONCATENATE formula combines the text from two cells into one cell. It does not matter whether the two cells have different types of data or even different formats.

1. Here’s how we can do it.

=CONCATENATE(A6:B6)

As you can see, it has combined our text.

Did you learn about how to combine text from two cells in Excel?. You can follow WPS academy to learn more features of Word documents, Excel Spreadsheets, and PowerPoint slides.

You can also download WPS Office to edit word documents, Excel Spreadsheets, and PowerPoint free of cost. Download Now! And get an enjoyable working space.