CONCATENATE FORMULA

CONCATENATE : -

Concatenate Formula is used for combine data from two or more columns into a single column.

When you concatenate cells in Excel, you combine only the contents of those cells. In other words, Concatenate in Excel is the process of joining two or more values together.

EXAMPLE :-

The simplest CONCATENATE formula to combine the values of cells A1 and B1 as follows

=concatenate(A1,B1)

As in below picture there are some texts in A & B column.

Now we want to combine result in Column C.

So we use CONCATENATE formula

=concatenate(A1,B1)

As per below...

And the Result come.

After that apply this formula to other cells for combine values.

As per below...

HOPE THIS INFORMATION IS HELPFUL FOR YOU.

THANKS