Excel mimics the capitalization and punctuation you use, so enter the names exactly as you want them to appear. Begin typing the next first and last name in the next cell in column C.

To merge or combine the first and last names in Excel you can make use of the CONCAT Ampersand, Flash Fill or TEXTJOIN functions or formulas.

You can combine text from multiple cells into one cell in Excel using the Ampersand symbol (&) or by using the CONCATENATE function.

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.

There are two situations in which you might need to merge two columns of data in Excel 2013. If you've imported two columns of data from separate sources, you might want to combine them into a ...