You can also click on a cell to enter it into the CONCATENATE function. First, you can type the cell references, separated by commas, after the opening parenthesis and then add a closing parenthesis at the end: =CONCATENATE(B2,A2) ![]() There are two ways you can enter the arguments. ![]() So, our two arguments for the function will be B2 and A2. We want to combine the first two columns, with the First Name (column B) first and then the Last Name (column A). Now, we enter the arguments for the CONCATENATE function, which tell the function which cells to combine. Start typing the function into the cell, starting with an equals sign, as follows. To begin, select the first cell that will contain the combined, or concatenated, text. ![]() We want to combine the Last Name and First Name columns in each row into the Full Name column. For example, we have a worksheet containing names and contact information. This function allows you to combine text from different cells into one cell. Concatenate is simply a fancy way ot saying “to combine” or “to join together” and there is a special CONCATENATE function in Excel to do this.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |