CONCATENATE()
Syntax. CONCATENATE(text1,text2,...)
Definition. This function joins several strings into a single string.
Arguments
text1,text2,...up to 30 strings. The strings to be joined into a single text string. The arguments can be strings, numbers, or single-cell references.
The examples for the TEXT() function have already demonstrated a use for this function. With this function, you can create dynamic text combining static and calculated strings.
Keep in mind that arguments are combined without delimiters (spaces or commas). Include delimiters in the arguments or use them as separate arguments. To enter a space, enclose the space in quotation marks (” “) or use the CHAR(32) function. The value 32 for the CHAR() function returns a space.
Instead ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
