Skip to content
# EXCEL FUNCTION – CONCATENATE

# 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?

### Example 1:- Concatenating the Values of Several Cells

###### Formula applied

###### Results

### 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:-

### Important Points

## Recommended Articles

## Similar Posts

### EXCEL FUNCTION – RIGHT

### EXCEL FUNCTION – LEN

### EXCEL FUNCTION – AND, OR, NOT

### EXCEL FUNCTION – SEARCH

### EXCEL FUNCTION – COLUMNS

### EXCEL FUNCTION – TRIM

**CONCATENATE** function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in a new cell.

**text**”, where we need to give the cell references, we can give multiple cell references as per the requirement to combine by following the “ , “ (i.e. Comma) as separator.

Formula =CONCATENATE(

**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:-

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)

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

RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.

LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.

AND, OR, NOT Functions” provide result in “TRUE” or “FALSE”. If the logical condition is correct and matching the parameters provided, then result would be “TRUE” or if logical condition is not correct and not matching the parameters provided then result would be “FALSE”

SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.

COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.

TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.