WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to combine only two text cells in Excel

August 1, 2022
4.6K Views

The combination of data of multiple cells in a single cell is required when the excel file is large due to presence of large amount of data. For managing and handling limited data is easy than to maintain large data. In organization of this type of data, combing two text cells is a more appropriate features. Merging of two text cells in excel is quite as same as combing multiple text cells. However, combining two text cells is a much easy process for producing a precise and accurate data.

Merging two text cells is also an important feature of excel that helps the users in managing and analyzing excel files consisting of limited data. It enables the excel users to maintain and finalize the data in a proficient way. There are many methods and techniques introduced by excel that helps its users to operate the feature of combining two text cells in a single cell. In this article we will discuss such methods that would prove to be beneficial for the readers. These method are compatible to 2016\2019\mac\online versions.

How To Combine Only Two Text cells In Excel By Using Merge Cells Function?

The most common and easy way of merging two text cells is the use of merge cells function. It is a simple and quick method of merging two text cells in a single cells. The steps for accessing this feature for the combination of two text cells in a single cell are as follows. This technique works with 2016\2019\mac\online versions.

1. First we will select the two text cell consisting of data we want to combine.

2. Then we will go to home tab and select the option merge and center.

3. From the drop-down we will select the option of merge content.

4. This will result in merging of data of two cells in a single cell.

This method is applicable for 2016\2019\mac\online versions.

How To Combine Only Two Text cells In Excel By Using CONCAT Function?

Using CONCAT function is another method of merging data of two text cells. This function consists of formula that results in combination of data of two text cells in a single cell. This function is commonly not used by excel users but it is an efficient technique of merging two text cells. The steps of this method are described below. It is a quite new function and it works with 2016\2019\mac\online versions.

1. First we will select the cell range i.e. two text cells which contain the data we want to combine

2. Then in the formula box we will enter the formula =CONCAT(A2,B2) for merging the data in cells A2 and B2.

3. The result will be production of a merged data of two text cells in a single cell.

This process is applicable for 2016\2019\mac\online versions.

How To Combine Only Two Text Cells In Excel By Using Format Cells?

Another method of merging two text cells is by using format cell dialog box. The steps of this process are as follows which works with 2016\2019\mac\online versions.

1. First we will select the cells we want to merge then we will open the format cell dialog box by pressing keys Crtl+1.

2. In the alignment segment we will select the option of merge cells.

3. This causes the data in the selected cells to merge.

This method is applicable for 2016\2019\mac\online versions.

Did you learn about how to combine only two text cells in excel using different methods? 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, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience. 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.