CONCATENATE Function (String Concatenation Function) in

This article provides a clear overview of CONCATENATE Function (String Concatenation Function) in, with the main facts, useful context, and practical details organized for easy reading.

The article describes the syntax, how to use the CONCATENATE function in Excel.

Description

The CONCATENATE function is used to concatenate multiple strings into a single string.

Syntax

= CONCATENTE (text1, text2.)

Arguments

- text1: the first string to connect.

- text2: is the string to connect to, up to 255 text strings to connect.

The connection string text1, text2. can be numbers, text, or cells that refer to numbers or text, separated by commas.

Note: You can use the ampersands (&) in operators instead of CONCATENATE to concatenate strings.

For Example

Concatenate text1 and text2:

= CONCATENATE (A6, B6)

Concatenate text1 and text2 with string ". vn":

= CONCATENATE (A8, B8, ". Vn")

Concatenate text1 + space + text2.

= CONCATENATE (A10, "", B10)

With simple syntax and usage, but sometimes you will need to use the CONCATENATE function to process data on Excel spreadsheets. You can easily remember the syntax of the function to use when needed. Good luck!