Combine 2 Cells in Excel With CONCAT The CONCAT function gives you the ability to combine the contents from one or more cells with any additional text you want.

You can combine two columns in Excel using several formulas and tools available in the software. If the columns that you want to combine are empty, you can use Excel's merge function.

How to Join Two Worksheets Together Using MS Excel. Whenever you create a new Excel document, you are opening what is called a "workbook." Each workbook can have multiple worksheets.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.