Excel 2010: Merge Cells (Concatenation)

While working on spreadsheet you might want to merge cells values into single column or row, which are widely dispersed in the spreadsheet. With Excel CONCATENATE function you can easily merge columns, rows and data values. It takes location of cells or data values as argument. In this post we will be applying this function to merge only two columns.

Launch Excel 2010 spreadsheet on which you want to apply concatenation function. For illustration, we have included a spreadsheet containing fields; First Name, Last Name, and Course.

Now we need to merge the content in First Name and Last Name columns. First we will be adding a new column and label it as Full Name.

fullname Excel 2010: Merge Cells (Concatenation)

We will be using a simple function that will concatenate the content.

The syntax of the function is;

=CONCATENATE(text1, text2….)

we will write it as;

=CONCATENATE(B2,” ”, C2)

In function arguments, B2 and C2 are the locations of data cells which we want to merge, and the double quotation marks with space inside “ ” refers to enforcing a single space between the values.

The function will merge the content of both fields in field Full Name, as shown in the screenshot below.

merge cells 1

Now drag the plus sign at the end of the cell towards the end of the column to apply this function over the whole column.

full name 1

you can also check out previously reviewed Excel function; DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *