![excel concatenate excel concatenate](https://i.ytimg.com/vi/T6bO4bjYS0w/maxresdefault.jpg)
To see the concatenation operator in action, let's rewrite the CONCATENATE formulas discussed above:Ĭoncatenate the values in A1 and B1 separated with a space:Ĭoncatenate the values in A1, B1 and a text string:Ĭoncatenate a string and the result of the TEXT / TODAY function: Similarly to the CONCATENATE function, you can use "&" in Excel to combine different text strings, cell values and results returned by other functions. This method comes in very handy in many scenarios because typing the ampersand sign (&) is much quicker than typing the word "concatenate" ? In Microsoft Excel, & operator is another way to concatenate cells. "&" operator to concatenate strings in Excel If at least one of the CONCATENATE function's arguments is invalid, the formula returns a #VALUE! error. For example, you should write =CONCATENATE(A1, A2, A3) instead of =CONCATENATE(A1:A3). Each cell reference must be listed separately. The result of the CONCATENATE function is always a text string, even when all of the source values are numbers.Įxcel CONCATENATE does not recognize arrays. In a single CONCATENATE formula, you can concatenate up to 255 strings, a total of 8,192 characters. To ensure that your CONCATENATE formulas always deliver the correct results, remember the following simple rules:Įxcel CONCATENATE function requires at least one "text" argument to work.
![excel concatenate excel concatenate](https://i.ytimg.com/vi/WpoC9zCmnuU/maxresdefault.jpg)
Using CONCATENATE in Excel - things to remember To make the result returned by some formula more understandable for your users, you can concatenate it with a text string that explains what the value actually is.įor example, you can use the following formula to return the current date: =CONCATENATE("Today is ",TEXT(TODAY(), "dd-mmm-yy")) Naturally, you can add a text string in the beginning or in the middle of your Concatenate formula as well: =CONCATENATE("See ", A1, " ", B1)Ī space (" ") is added in between the combined values, so that the result displays as "Project 1" rather than "Project1".Ĭoncatenating a text string and a formula-calculated value. Please notice that we add a space before the word " completed" to separate the concatenated text strings. The above formula informs the user that a certain project is completed, as in row 2 in the screenshot below. For example: =CONCATENATE(A1, " ", B1, " completed") You can also use it to concatenate various text strings to make the result more meaningful. There is no reason for the Excel CONCATENATE function to be limited to only joining cells' values. Concatenating a text string and cell value To separate the concatenated values with other delimiters such as a comma, space or slash, please see Excel CONCATENATE formulas with special characters.
![excel concatenate excel concatenate](https://cdn.ablebits.com/_img-blog/excel-concatenate/concatenate-range-excel2.png)
To separate the values with a space, enter " " in the second argument, as in row 3 in the screenshot below. Please note that the values will be knit together without any delimiter, as in row 2 in the screenshot below. The simplest CONCATENATE formula to combine the values of cells A1 and B1 is as follows: =CONCATENATE(A1, B1) Where text is a text string, cell reference or formula-driven value.Įxamples: Concatenating the values of several cells The syntax of Excel CONCATENATE is as follows: CONCATENATE(text1,, …) The CONCATENATE function in Excel is designed to join different pieces of text together or combine values from several cells into one cell.
Excel concatenate how to#
In General, there are two ways to combine data in Excel spreadsheets:ĬONCATENATION in Excel How to use the CONCATENATE function Excel
![excel concatenate excel concatenate](https://officepowerups.com/wp-content/uploads/2015/11/pwrconcatenate.png)
In this article, we will learn How to concatenate or merge in Excel.