How do I combine the information from two columns in Excel into one column?



Excel-PasteIf you have first names in column “A2” and last names in column “B2” you can combine them into one column with a simple formula.
Just type the following formula in cell C2: =A2&” “&B2 and use the fill option to copy all the names into the “C” column.
Now you will need to delete the first two columns: Highlight and copy column “C” and then click on “Paste Options” and choose the first option under “Paste Values.” This removes the formula from column “C” and you are able to delete the first two columns.

Posted in: Excel Formulas, Microsoft Excel