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

### What is VLOOKUP in Excel?

### EXCEL FUNCTION – AVERAGEIF

### EXCEL FUNCTION – IFS

### EXCEL FUNCTION- LEFT

### EXCEL FUNCTION – COUNTIF

### EXCEL FUNCTION – SUMIF

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.

An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.

AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.

What is COUNTIFS in Excel? The Microsoft Excel COUNTIFS function counts the number of cells in a range, that meets a single or multiple criteria and adjacent or non-adjacent. As a Statistical function of Excel,…

LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell

Excel Function COUNTIF COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You…

SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.