The Concatenate function

Given that you imported data into excel with the First Name and Surnames in separate cells – The Concatenate function can be used to join the cells and have the First Name first, then the Surname. This will obviously automate the process of data entry meaning you can work smarter and effectively.

Applies To: Excel 2003, 2007 and 2010

  1. The screen shot below will be used for this example

2.  Select cell C2 and as below

 3.   Enter as below 

 The result will be as displayed below.  The first Names and Surnames have been joined into one cell.

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations