How to Use the CONCATENATE Function in Excel

When you need to join text together in Excel to come up with a single text string, then Excel has a special function to perform such tasks. The CONCATENATE function is designed to joint 2 or more items together and returns the result as a text value. The CONCATENATE function can join together up to 255 items, up to a maximum of 8,192 characters.

The Basic Excel CONCATENATE Function

Syntax of Excel CONCATENATE function is;

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

An Explanation of the Formula

The CONCATENATE function has several criteria:

  • These text items can be text strings, numbers, or cell references and resulting value is a text string.
  • Number values are converted to text string after joining.
  • Space character can be joined within this function between 2 items.
  • When you join Date or Time value, CONCATENATE function returns serial number as a text string.
  • Ampersand character (&) is used an alternative to CONCATENATE function.

Example of the CONCATENATE Function

For example, if you want to join text together in Excel, then these items can be inserted in CONCATENATE function directly or as a cell reference, such as;

=CONCATENATE("ABC",123)

OR

=CONCATENATE(A1,A2)

Here are some Excel CONCATENATE function examples and you will learn how to use the CONCATENATE function.

Concatenate Space Characters

When you join text together the resulting string might get confusing to read and understand, so you can add or join space character(s) between text items to separate your concatenated values. You can add space character(s) as parameter or argument in CONCATENATE function to separate the values.

For example, you have 3 items and you want to concatenate these text item with space character along with other symbols like “$” and “/” to get the resulting text string as given below using following formula;

=CONCATENATE(A2," ","$",B2,"/",C2)

 

 

The same results can be achieved using Ampersand operator (&) to join text together along with space character and other symbols to return the text string. Each cell reference or parameter or value is joined by Ampersand operator (&), such as;

=A2&" "&"$"&B2&"/"&C2

 

Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free. 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar