Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text > CONCATENATE
 

CONCATENATE (text1, text2 [,text3] [,...])

 
 Returns the text string that is a concatenation of several strings.

 text1The first text string.
 text2The second text string.
 text3The third optional text string.

 REMARKS
 
  		• Arguments can be text strings, numbers, or single-cell references.
     
  		• This function is equivalent to the "&" character.
     
  		• If you concatenate a cell that contains a numerical value, the result is converted to text. See Example 5
     
  		• If you concatenate a cell that is formatted as a date, the date serial number will be used. To avoid this problem you can use the TEXT() function to convert the date into a recognisable date format before it gets concatenated.
     
  		• You can have a maximum of 30 arguments.

     EXAMPLES
     
     AB
    1=CONCATENATE("the start"," and the end") = the start and the endone
    2=CONCATENATE("ab","cd","ef","gh") = abcdefghtwo
    3=CONCATENATE(IF(20<10,1,"first"),IF(20<5,1,"second")) = firstsecondthree
    4=CONCATENATE(1,2,3,4) = 1234200
    5=CONCATENATE(B4) = 20012/16/1998
    6=CONCATENATE("Date is : ",B5) = Date is : 36145 
    7=CONCATENATE("Date is : ",TEXT(36145,"dd-mmm-yy")) = Date is : 16-Dec-98 
    8=CONCATENATE(B1," ",B2," ",B3) = one two three 
    		 
     Functions - C | Index - C | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top