Consolidating columns excel 2016
The function you just entered is copied down to the rest of the cells in that column, and the cell references are changed to match the row number for each row.
You can also concatenate text from multiple cells using the ampersand (&) operator. There’s no real advantage of using one over the other.
We want to combine the Last Name and First Name columns in each row into the Full Name column.
Excel Tactics is dedicated to helping you master it.The fill handle allows you to quickly copy and paste content to adjacent cells in the same row or column.Move your cursor over the fill handle until it turns into a black plus sign and then click and drag it down.We want to combine the first two columns, with the First Name (column B) first and then the Last Name (column A).So, our two arguments for the function will be B2 and A2. First, you can type the cell references, separated by commas, after the opening parenthesis and then add a closing parenthesis at the end: You can also click on a cell to enter it into the CONCATENATE function.