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)
