How to merge text in Excel

To attain the desired result, we may need to combine several cells into one. Excel undoubtedly has some of the quickest features for doing that, including the answer of how to merge text in excel.

The dataset below will be used for our projects today. First name and last name are mentioned here. And the text from these two cells needs to be combined.

Lets see how to merge text in excel.

Merge text using Ampersand symbol without separator in excel online, 2016 and 2019:

You can use the ampersand symbol in the formula below to combine text from two cells without using separators and without including any space characters.

=B5&C5

  1. The first name starts in cell B5 in this example, and the last name starts in cell C5.
  • You can achieve the following output by entering the formula in the D5 cell, selecting the Fill Handle Tool, and dragging the green little square to the right bottom of the cell.

How to merge text using the CONCATENATE function in excel:

Multiple strings are combined into one string using the CONCATENATE function. Therefore, we can combine text using the function.

=CONCATENATE(B5,” “,C5)

  1. The first name starts in cell B5 in this example, and the last name starts in cell C5.
  2. The Fill Handle Tool will provide the results shown below if you press Enter while using it.

How to merge text using CONCAT function in excel:

As you are aware, WPS suggests utilizing the CONCAT function rather than the CONCATENATE function. The CONCAT function likewise creates a single string by combining numerous strings, but it lacks a predefined delimiter. However, if you like, you can manually enter the delimiter.

  1. The following formula must be used if we wish to extract the whole name from the two cells using the function.

=CONCAT(B5,” “,C5)

  • The first name starts in cell B5 in this example, and the last name starts in cell C5.

What’s more, the CONCAT function has a unique property in that it can combine a variety of cells.

  • Use the formula below if you need to merge a variety of texts.

=CONCAT(B5:C5,” “,B6:C6)

  • Here, the name is displayed in cells B5 and C5, whereas the belonging state’s name is displayed in cells B6 and C6.
  • You will get the results listed below if you press Enter after repeatedly entering the formula into additional cells.

Note: This above written article is an attempt to show you how to merge text using different functions in excel online, 2016 and 2019, in both windows and mac.

You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.    

If you like this article, please share it with your friends

Leave a Reply

Your email address will not be published. Required fields are marked *