CONCATENATE function (string concatenation function) in Excel

Use the CONCATENATE function when you want to concatenate existing text strings into a single, complete text string. For the syntax and usage of the CONCATENATE function, follow the article below.

CONCATENATE function (string concatenation function) in Excel Picture 1

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 .)

Inside:

- 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 function (string concatenation function) in Excel Picture 2

Concatenate text1 and text2 with string ".vn":

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

CONCATENATE function (string concatenation function) in Excel Picture 3

Concatenate text1 + space + text2.

= CONCATENATE (A10, "", B10)

CONCATENATE function (string concatenation function) in Excel Picture 4

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!

Marvin Fry

Update 19 May 2020

You should read it

May be interested

TRIM (function to remove spaces in text) in Excel
the trim function is a function that removes all spaces in the input text and keeps a space between words.
DEVSQ function in Excel The function returns the sum of squares of deviations between data points from their average
devsq () is a function that returns the sum of squares of deviations between data points from their average.
PROPER function in Excel
the proper () function capitalizes the first letter in a text string if it's a non-letter character (for example, a space) and converts all other letters to lowercase.
REPLACE and REPLACEB (replace part of the input text string) in Excel
the replace () and replaceb () functions are both functions that replace a part of the input text string.
The UNICHAR () and UNICODE () functions in Excel
the unichar () and unicode () functions are used for unicode charsets, you can get unicode characters from the numeric input value with unichar () and vice versa, get numeric values from the first unicode character. on with the unicode () function.
LEN () and LENB () functions in Excel
the len () function returns the number of characters in the input text string. the lenb () function returns the number of bytes used to represent characters in the input text string. the lenb function only comes to 2 bytes per character when the default language is one of the languages that supports dbcs.