Mark Coppock/Digital Trends Using the Concatenate function to merge cells in Microsoft Excel Sometimes we want to take two columns and merge them into one, keeping the information from both columns.

Common examples of Excel functions include SUM, AVERAGE, and MIN. More advanced common Excel functions include using VLOOKUP to find specific data, and using IF to make a conditional formula.