CONCATENATE Function in Excel
Function should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”.
How to Use Concatenate Function in Excel?
The CONCATENATE function allows you to combine text from different cells into one cell. In our example, we can use it to combine the text in column A and column B to create a combined name in a new column. Before we start writing the function, we’ll need to insert a new column in our spreadsheet for this data. Lets learn with few examples given below:-
Example 1:- Concatenating the Values of Several Cells
As we can see in the below images by applying simple CONCATENATING Formula two cell values are easily combined into one.
Formula =CONCATENATE(A2,” “,B2)
Example 2 :- Concatenating a Text String and a Cell Value
The Excel CONCATENATE function is not only combined cell values. we can use the function to join a cell value and a string as well. For example:-
- There should be at least one “text” argument in the CONCATENATE function.
- If the CONCATENATE function’s arguments are invalid, the formula returns a #VALUE! Error.
- The result of the CONCATENATE function is always a text string, even when all the source values are numbers.