How to combine text in excel

When you're working with Excel, you may find yourself in a situation where you have a long list of text that needs to be combined. It could be a list of names and phone numbers or a list of email addresses. You might even have a long list of quotes or product descriptions that you want to combine together. Whatever the reason, this blog post will show you how to combine text in Excel so that you can make your lists look more professional and save yourself time when writing them out.

How to combine text in excel using the & (Ampersand) Operator?

If you've ever had to merge two or more pieces of text in Excel, you know it can be a pain. The & (Ampersand) operator is a simple way to combine text together and make it easier for your users to read.

This method works best with versions 2016/2016/mac/online.

1. To combine data from multiple cells, first select the cell in which you want to display the merged data.

2. Then start the formula with an equal sign (=). Choose the cell that contains the initial text for your merged string; this cell is often the first cell of your new merged range.

3. Next, enter an &  operator to combine those cells.

4. Finally, choose the cell that contains your final text; this cell will often be last in your merged range.

5. Press Enter when you're done to complete the formula.

How to combine text in excel using CONCATENATE function?

The concatenate formula is a very useful tool in Excel. It can be used to combine text into one cell, or to join more than two cells into one cell, providing all the data in the right place.

This method works best with versions 2016/2016/mac/online.

1. First of all, select the cell where you want to see the combined text.

2. After that, type the formula with the given syntax

CONCATENATE(Text1, Textl2)

Where,

Text1 is the cell containing the initial text.

Text2 is the cell containing the final text.

3. Press Enter when you're done to complete the formula.

How to combine text in excel using CONCAT function?

Just like CONCATENATE function the CONCAT function allows you to combine text in excel. It works in a similar way to the & operator in Excel, but it can also work with multiple cells and handle quotes.  Here's how the CONCAT function can help you.

This method works best with versions 2016/2016/mac/online.

1. First of all, select the cell where you want to see the combined text.

2.  After that, type the formula with the given syntax:

CONCAT(Text1, Text2)

Where,

Text1 is the cell containing the initial text.

Text2 is the cell containing the final text.

3. Press Enter when you're done to complete the formula.

Did you learn about how to combine text in excel? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.