How to combine text from two cells in Excel
A free Office suite fully compatible with Microsoft Office
You can exhale with relief if you have a huge worksheet in an Excel workbook where you need to mix content from many cells because you don't have to retype it all. The text is simple to concatenate.
The CONCATENATE function in Excel can be used to accomplish this. Concatenate is just a fancy way of expressing to combine or to join together. You can combine text from various cells into one cell with this function. As an illustration, we have a worksheet with names and contact details. Each row's Last Name and First Name columns should be combined to form the Full Name column.
Let’s see how to combine text from two cells in excel.
1.Select the first cell that will hold the merged or concatenated text to get started. Enter the following function into the cell, beginning with
an equals sign:=CONCATENATE(
2.The CONCATENATE function's arguments, which specify which cells to combine, are now entered. The first name (column B) should come first, followed by the last name, and the first two columns should be combined (column A). Therefore, B2 and A2 will be our two arguments for the function.
2.There are two methods for introducing arguments. After the initial parenthesis, you can type the cell references, separated by commas, and then include a closing parenthesis at the end:=CONCATENATE(B2,A2)
3.Additionally, you can click a cell to add it to the CONCATENATE function. In our example, after entering the function's name and the opening parenthesis, we click on the B2 cell, enter a comma in the function after B2, then click on the A2 cell, entering the closing parenthesis in the function after A2.
4.Once you have finished adding the cell references to the function, press Enter.
Notice that there is no space in between the first and last name. That’s because the CONCATENATE function combines exactly what’s in the arguments you give it and nothing more. There is no space after the first name in B2, so no space was added. If you want to add a space, or any other punctuation or details, you must tell the CONCATENATE function to include it.
6.We provide a space as an additional argument to the function, in between the cell references, to insert a space between the first and last names. To accomplish this, we enter a space between two double quotes. Make careful you use commas to separate the three arguments.=CONCATENATE(B2, ,A2)
Better still. The first and last names are separated by a space at this point.
Note: This above written article is an attempt to show you how to combine text from two cells 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.
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences