CONCATENATE Function | Excel

The CONCATENATE function is used to join two or more words or text strings together. The syntax for the CONCATENATE function is:

= CONCATENATE ( text1, text2, ... text255 )

where text1, text2, ... text255 can be words, cell references, blank spaces, or numbers where each entry is separated by a comma. The concatenate function does not automatically leave a blank space between words or other data.

An example of the CONCATENATE function is:



You can copy and paste special just the values to eliminate the function and retain just the concatenated text.