Lori Kaufman is a technology expert with 25 years of experience. She"s to be a an elderly technical writer, functioned as a programmer, and also has even run her very own multi-location business. Review more...
You are watching: Combining two or more selected cells into one cell is called
If you have actually a big worksheet in an Excel workbook in which you need to combine text from multiple cells, you can breathe a sigh the relief because you don’t have to retype all that text. Friend can easily concatenate the text.
Concatenate is just a fancy way ot saying “to combine” or “to sign up with together” and there is a distinct CONCATENATE function in Excel to carry out this. This duty allows you to integrate text from different cells into one cell. Because that example, we have actually a worksheet include names and contact information. We desire to incorporate the Last name and very first Name columns in each row into the full Name column.
To begin, select the very first cell that will contain the combined, or concatenated, text. Begin typing the role into the cell, beginning with an equals sign, together follows.
Now, we go into the debates for the CONCATENATE function, which phone call the duty which cells to combine. We want to combine the first two columns, through the very first Name (column B) very first and then the Last surname (column A). So, our two debates for the duty will it is in B2 and A2.
There room two means you can get in the arguments. First, you can form the cell references, be separated by commas, ~ the opened parenthesis and then add a close up door parenthesis in ~ the end:
You can also click ~ above a cabinet to go into it into the CONCATENATE function. In ours example, after inputting the surname of the role and the opened parenthesis, we click the B2 cell, type a comma after B2 in the function, click on the A2 cell, and also then form the close up door parenthesis after A2 in the function.
Press enter when you’re done including the cell referrals to the function.
Notice that there is no space in between the first and last name. That’s since the CONCATENATE role combines precisely what’s in the debates you provide it and also nothing more. Over there is no room after the first name in B2, so no an are was added. If you desire to add a space, or any kind of other dot or details, you need to tell the CONCATENATE duty to encompass it.
To include a space between the first and last names, we include a room as another argument to the function, in in between the cabinet references. To carry out this, we kind a space surrounded by dual quotes. Make certain the three debates are separated by commas.
=CONCATENATE(B2," ",A2)Press Enter.
That’s better. Now, over there is a an are between the very first and critical names.
RELATED: How to immediately Fill Sequential Data right into Excel through the to fill Handle
Now, you’re more than likely thinking you have to form that duty in every cell in the pillar or manually copy it to each cell in the column. Actually, friend don’t. We’ve got one more neat trick the will assist you quickly copy the CONCATENATE duty to the other cells in the shaft (or row). Choose the cell in which girlfriend just gone into the CONCATENATE function. The little square on the lower-right corner of the selected is called the fill handle. The fill handle allows you to quickly copy and also paste content to nearby cells in the exact same row or column.
Move her cursor over the fill manage until that turns right into a black plus sign and also then click and also drag that down.
The function you just entered is replicated down come the rest of the cells in that column, and the cell recommendations are readjusted to enhance the row number for each row.
See more: Is Ice Cream Melting A Chemical Change ? Physical And Chemical Changes In The Kitchen
You can also concatenate text from multiple cells making use of the ampersand (&) operator. For example, friend can go into =B2&" "&A2 to get the same result as =CONCATENATE(B2,” “,A2) . Yes sir no real benefit of making use of one over the other. Although utilizing the ampersand operator results in a much shorter entry. However, the CONCATENATE duty may be more readable, making it less complicated to understand what’s continue in the cell.