Excel 2007 CONCATENATE Function

The CONCATENATE function, one of Excel's text functions, is used to join two or more words or text strings together.

The syntax for the CONCATENATE function is:

= CONCATENATE ( text1, text2, ... text30 )

Text1, text2, ... text30 can be words, cell references, blank spaces, or numbers.

Example Using Excel's CONCATENATE Function:

Note: For help with this example, see the image to the right.

1. Enter the following data into specified cells:
   D1 - 4,
   E1 - hours
   
   
2. Click on cell D3 - the location where the results will be displayed.
   
   
3. Click on the Formulas tab.
   
   
4. Choose Text Functions from the ribbon to open the drop down list.
   
   
5. Click on CONCATENATE in the list to bring up the function's dialog box.
   
   
6. On line Text 1 of the dialog box, type in the words "We will arrive
   in ".
   
   Note: Notice that I have included a blank space after the word in. This is done to separate the parts of the concatenated sentence in cell D3.
   
   
7. On line Text 2 of the dialog box, click on cell D1.
   
   
8. On line Text 3 of the dialog box, press the space bar to add a blank space.
   
   
9. On line Text 4 of the dialog box, click on cell E1.
   
   
10. Click OK.
    
    
11. The concatenated sentence "We will arrive in 4 hours" should appear in cell D3.
    
    
12. The complete function = CONCATENATE ("We will arrive in ", D1 ," ", E1) appears in the formula bar above the worksheet.

• Excel 2007 RIGHT Function
• Excel 2007 LEFT Function
• Excel 2007 MID Function