CONCATENATE

Joins several text strings into one text string.
Syntax
CONCATENATE (text1,text2,...)
Text1, text2, ...    are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.
Remarks
The "&" operator can be used instead of CONCATENATE to join text items.
Example
The example may be easier to understand if you copy it to a blank worksheet.

	A
1	Data
2	brook trout
3	species
4	32

 

Formula	Description
=CONCATENATE("Stream population for ",A2," ",A3," is ",A4,"/mile")	Concatenates a sentence from the data above (Stream population for brook trout species is 32/mile)

Related Posts :