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.
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
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.