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

CONCAT vs. TEXTJOIN: Which function should I choose to concatenate data?
both concat and textjoin help you to concatenate data in different cells. let's learn how to use tipsmake.com.com, the difference between them to see which function you should choose to join the data!
How to use the LEN function in Excel
the len function in excel is used to measure the length of a certain string of characters, including spaces and correctly return the total character for the user.
LEFT function in Excel, how to use LEFT function and illustrative examples
left function in excel, how to use left function and illustrative examples. left function in excel is a function of string processing function, you use left function when you need to cut the character string to the left of the text string. if you need to learn more about mid functions, be patient
How to use the FIND function in Excel?
the find function in excel is a function that finds characters in a text string, having the same purpose as string separators like the mid function in excel or the left function or the right function.
RIGHT function, how to use the right-cut string function in Excel
right function in excel is a function that takes characters from the right in a string.
ENCODEURL function - The function returns a query string with URL code in Excel
encodeurl function: the function returns a query string with the url code. support functions from excel 2013 onwards. syntax: encodeurl (text)
String (String) in PHP
string is a sequence of characters, you will find available string handling functions in php at php string (string) handler
Find, FindB functions in Excel - The function finds a text string in another document in Excel
the find and findb functions help you find a text string in another text and return the value as the location of the text string to be found in the search text. depending on the different default languages that you apply the find or findb function properly.
How to use the Search function in Excel
the search function in excel is used to search for the position and order of a text string, so you can find the position of the word or the data you need.
How to use the TEXTJOIN function in Excel 2016
the textjoin function concatenates text from multiple ranges and / or strings, which includes a delimiter between the connected text value. if the delimiter is an empty text string, this function effectively matches the ranges.