Consolidating columns excel 2016

Rated 4.94/5 based on 554 customer reviews

The formula in the Function column of the preceding example table uses the CONCAT function to combine the contents of three cells in columns A, B, and C.In the function, you separate the cells or strings that you want combined by commas.Merging allows you to combine a cell with adjacent empty cells to create one large cell. If you merge multiple cells that all contain data, Excel will keep only the contents of the upper-left cell and discard everything else.Merging can be useful for organizing your data, but it can also create problems later on.

Microsoft Excel is a hugely popular piece of software that comes bundled with Microsoft Office.

If you have a lot of rows of data where you want to combine text, you don’t have to repeat the above procedure for every row.

For example, if column A contains peoples’ first names and column B has all their last names, and you want to fill column C with all their first and last names combined, you can simply start typing the combined text in column C and Excel will fill in the rest for you.

The Merge Cells joins various types of data such as names, numbers, dates, special symbols or text.

You can separate the merged cells with any character, including the line break or carriage return.

Leave a Reply