Consolidating columns excel 2016
Sign up and you'll get a free guide with 10 time-saving keyboard shortcuts!
If you have a large worksheet in an Excel workbook in which you need to combine text from multiple cells, you can breathe a sigh of relief because you don’t have to retype all that text. 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.
Select the cell in which you just entered the CONCATENATE function.
The small square on the lower-right corner of the selected is called the fill handle.
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.
This function allows you to combine text from different cells into one cell.
It should look like this: The steps that follow will show you how to get to this result.The fill handle allows you to quickly copy and paste content to adjacent cells in the same row or column.