CONCAT
Merges text from several ranges and/or individual strings.
Syntax
 Copy Code
|
|---|
CONCAT(Any text1, Any text2, ... ) → String |
text1 | Required. Text items to be joined. A string or array of strings, such as a range of cells. |
text2 | Optional. Additional text items to be joined. |
Function Reference
INDEX Function
MATCH Function
OFFSET Function
HLOOKUP Function