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. 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. 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.
In General, there are two ways to combine data in Excel spreadsheets:ĬONCATENATION in Excel How to use the CONCATENATE function Excel In this article, we will learn How to concatenate or merge in Excel.