Merging Adjacent Cells in Excel

2008 Jan 11

The merge and Center button in Excel only centers the top left text and deletes the rest. What if the two columns of First names and last names are to be merged into the format: Last name, First name it would then become a problem.

Using the Ampersand ( & ) operator, it allows us to merge cells in an excel worksheet. you can create a formula to merge cells in excel or just insert it right away on the cell formula bar.

Problem:
And you wish to merge the two cells at A1 and A2 to the cell at A3

Given:
Cell A1 has the text "Lastname"
Cell A2 has the text "Firstname"

Solution:
* First position your active cell on A3.
* On the formula bar input the following: =A1&A2 [ENTER]

It should display LastnameFirstname on cell A3

To add a space and a comma, use the following:
=A1&", "&A2
it will output: Lastname, Firstname

alternatively you can also use the concatenate function, like this:
=CONCATENATE(A1,", ",A2)

Tweet this post

Leave a comment


About Me


Alfredo Sanchez is an internet professional focusing on the study search engines behavior in particular. Supports Free Open Source Software and currently develops applications with it using XAMPP.

Recent Entries

Close