The basic Syntax of CONCAT:
CONCAT (X1, X2, ...)
The arguments can be text strings or their respective cell references, and users can also add commas, hyphens, spaces, etc., to custom and format the resulting text. Following is an example:
Sunday, 4 September 2016
Excel Text Functions (I) - Concatenating text strings
"CONCAT" (Excel 2016) or "CONCATENATE" (earlier versions) is the Excel function used to join two or more text strings into one.
The basic Syntax of CONCAT:
CONCAT (X1, X2, ...)
The arguments can be text strings or their respective cell references, and users can also add commas, hyphens, spaces, etc., to custom and format the resulting text. Following is an example:
Our arguments include 5 text strings located in cells A1 to A5, in between them we have added three spaces and one comma. The resulting string is as follows (at cell A7):
The function can expand to concatenate data in cells of different columns:
By copying formula in E2, we can easily extend the concatenating actions towards other rows:
The basic Syntax of CONCAT:
CONCAT (X1, X2, ...)
The arguments can be text strings or their respective cell references, and users can also add commas, hyphens, spaces, etc., to custom and format the resulting text. Following is an example:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment