Excel Tip - Combining Data in Separate Cells

Sometimes data that you are working with isn’t always laid out as you need it to be.  You may have information in separate columns, that you need to combine into one cell.  In this example we will show you how to do just that...

  • In this example, you can see that the data in column A, B, C is combined to create a mailing name for mailshot addressing purposes:

 

  • Click into an empty cell adjacent to the data to be combined

 

  • Type an Equal symbol = then click on the first cell to be combined, in our example, that will be C2 “Miss”

 

  • Then type the Ampersand symbol “&“

 

  • To add a space between the Title and the Firstname, we must type a space within quotation marks.  Type a speech mark symbol , followed by pressing the Spacebar, then another speech mark symbol , it will look like this:

 

  • Type another and click on the second cell to be combined, in our example this will be the Firstname "Liz" in B2:

 

  • Type another &
  • We will add another space by typing a speech mark symbol , followed by pressing the Spacebar, then another speech mark symbol
  • Type another and click on the third cell to be combined, in our example this will be the Lastname “Abraham” in A2:

 

  • Press Enter to finish the formulae or continue if you have other data to combine, remembering to add the symbol for each entry required

 

  • To copy the formulae down, double click on the Auto Fill handle in the corner of formula cell:

 

  • The formulae will be copied down to the end of the data:

  • Using the Ampersand symbol to combine data, allows you to quickly join your data typed in multiple columns. You can use any keyboard symbols you like when combining your data if they are surrounded by quotation marks.  Combining data helps you to make unique ID codes for your data so you can identify your records easily or detect duplicate records.  It also saves you time so you do not have to retype entries just to get them to look the way you need them to.
Pin it