2] Apply Same Formula to Multiple Cells in Excel using AutoFill feature Here we are at the second approach that works quite well, so let us discuss this right now.

None of the spaces here are required. As you can see in the screenshot below, the formula works without these spaces. You can access an Excel workbook and accompanying video below for combining a ...

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.