How to Combine First & Last Name Columns in Excel. In previous versions of Excel, you had to combine first and last names using the Concatenate function, or its shortcut "&" method. Those methods ...

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.

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

Irene Galente asked if she can combine the name data in a number of Excel columns into a single cell. In Irene’s spreadsheet the first column displays each person’s “title” … ...

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

If your source data is in Excel and has duplicates, run Power Query to remove those duplicates before running a Word mail merge.

In part three, you're finally ready to use the data you exported from Outlook to Excel, to create a mail merge with a Word document.

While you could tediously copy and paste names and addresses from a text document, with a little know-how in Excel, you can make the process far easier.