[Excel] CONCATENATE Function
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.