#MERGING CELLS IN EXCEL ONLINE HOW TO#
#MERGING CELLS IN EXCEL ONLINE FULL#

Select the cell in which you just entered the CONCATENATE function. WeвЂ™ve got another neat trick that will help you quickly copy the CONCATENATE function to the other cells in the column (or row). Now, youвЂ™re probably thinking you have to type that function in every cell in the column or manually copy it to each cell in the column.

#MERGING CELLS IN EXCEL ONLINE HOW TO#

RELATED: How to Automatically Fill Sequential Data into Excel with the Fill Handle Now, there is a space between the first and last names. Make sure the three arguments are separated by commas. To do this, we type a space surrounded by double quotes. To add a space between the first and last names, we add a space as another argument to the function, in between the cell references. If you want to add a space, or any other punctuation or details, you must tell the CONCATENATE function to include it. There is no space after the first name in B2, so no space was added. ThatвЂ™s because the CONCATENATE function combines exactly whatвЂ™s in the arguments you give it and nothing more. Notice that there is no space in between the first and last name. Press Enter when youвЂ™re done adding the cell references to the function.

In our example, after typing the name of the function and the opening parenthesis, we click on the B2 cell, type a comma after B2 in the function, click on the A2 cell, and then type the closing parenthesis after A2 in the function. 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.

#MERGING CELLS IN EXCEL ONLINE FULL#

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.

Merging cells in excel online