Explainry Tutorials to Expert in IT

CONCATENATE function in Excel


CONCATENATE, one of the text functions is used to join different text strings to a single string. A string may be a text value, number and cell reference.


=CONCATENATE(text1, [text2], …)


text1 is the first string that can be a text value, number and cell reference and

text2, … are additional strings to join, you can join up to 255 items, up to a total of 8,192 characters.


We have four text values in cell A1, B1, C1, and D1, do the following steps to create a single sentence or word in a worksheet:

1. Select a cell, type =CONCATENATE and select these cell references;(A1,B1,C1,D1) then press Enter.

2. Excel will create a new combined text value, ABCD.

Add a space character

1. To add a space character between alphabets, type =CONCATENATE(A1, ” ” , B1) and press Enter.


2. Excel will create a space between alphabet A and B,

Add a comma

Type =CONCATENATE(A1, ” , ” , B1) and press Enter, Excel will create a comma between alphabet A and B.


Add “&” character between strings

To add “&” character, type Type =CONCATENATE(A1, ” & ” , B1) and press Enter.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved