My friend asked me a question on how to merge First Name and Last Name into a single column in Excel instead of copy and paste the content from Column A and Column B to Column C 1 by 1. To solve his problem, they is a simple way to do that by using Concatenate function in Excel.

In Excel, the Concatenate function allows you to join character strings from several cells together in another destination cell.

The syntax for the Concatenate function is:

Concatenate( text1, text2, … text_n )

n = Up to 255 text entries can be added and entry must be separated by a comma. (more…)

Tags: Excel 2007 CONCATENATE Function, How to Concatenate Text in Microsoft Excel, How to Use Excel's Concatenate Function, Joining Two Text Columns