CONCAT

The CONCAT function joins (concatenates) values or the contents of cell ranges or strings.

CONCAT replaces the CONCATENATE function, but CONCATENATE is still available for compatibility purposes.

CONCAT(string, string…)

string: Any value. Can also be a cell or a range of cells.

string…: Optionally include one or more additional values or cell references.

Notes

Examples

Given A1=1, A2=2, A3=3, B1=A, B2=B, and B3=C:

=CONCAT(A,B) returns "123ABC".

=CONCAT(B1:B2, A2:A3) returns "AB23".

="A"&"B"&"2"&"3" also returns "AB23", because & is the concatenation operator.

See alsoCONCATENATETEXTJOIN
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.