Related Function:

Excel string concatenation, i.e. joining together text strings, can be performed by using the: 

Using the Ampersand (&) Operator

The & Operator, when used between two text strings, tells Excel to return a single text string, consisting of the concatenation of the two original strings.

Syntax

=text1&” “&text2&” “&[text3]&” … )

Examples

  A B C D E
1 FirstName LastName DOB Formula Result
2       =”John”&” “&”Jones” John Jones
3 Barbara BUSH   =A2&” “&B2 Barbara BUSH
4 George BUSH 11/12/85 =A3&” “&B3&”, DOB:”&TEXT(C3,”mm/dd/yy”) George BUSH, DOB: 11/12/85

Usage note:

  • Spaces have been added to separate the different fields, e.g. in cell D2, a space, encased in quotes, has been used to separate the first and last name
  • The TEXT function has been used in cell D4 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

Using the CONCATENATE Function

The CONCATENATE function returns the concatenation of two or more supplied text strings.

Syntax

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

Examples

  A B C D E
1 FirstName LastName DOB Formula Result
2       =CONCATENATE(“John”,” “,”Jones”) John Jones
3 Barbara BUSH   =CONCATENATE(A3,” “,B3) Barbara BUSH
4 George BUSH 11/12/85 =CONCATENATE(A4,” “,B4,”, DOB: “,TEXT(C4,”mm/dd/yy”)) George BUSH, DOB: 11/12/85

Usage note:

  • Spaces have been added to separate the different fields, e.g. in cell D2, a space, encased in quotes, has been used to separate the first and last name
  • The TEXT function has been used in cell D4 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