The CONCATENATE function joins together a series of supplied text strings or other values, into one combined text string.

Syntax

=CONCATENATE(text1,text2,[text3],…)

Arguments

Argument Description
text1 The first text, string, or value
text2 The second text, string, or value to join to the first
[text3] Additional text, strings, or values to join together

Note: Beginning in Excel 2007 and later versions of Excel, you can supply up to 255 text arguments to the Concatenate function, but in Excel 2003, the Concatenate function can only accept up to 30 text arguments.

Examples

  A B C D E
1 First Name Last Name DOB Formula Results
2 Barbara BUSH   =CONCATENATE(A2,” “,B2) Barbara BUSH
3 George BUSH   =CONCATENATE(A3,” “,B3) George BUSH
4 John JONES 11/12/85 =CONCATENATE(A4,” “,B4,” ,DOB: “,TEXT(C4,”dd/mm/yy”)) John JONES, DOB: 11/12/85

Usage note:

  • Spaces have been added to separate the different fields. For example, in cell D2, a space, encased in quotes, has been used to separate the first name and last name.
  • In cell D4, the Text function has been used to convert the date value in cell C4 into a string, using the date format “dd/mm/yy”. If the date was not converted in this way, the date part of the returned string would be displayed as the date’s integer value.