Wednesday, June 29, 2011

How to create a full name from first name and last name located in two cells

You can create a full name from first name and last name encoded in different cells by using a formula. i.e, =a2&" "&b2

If u want in the complete name to be family name first use, this formula: =b2&", "&a2


1. Click on the cell where you want to create the full name(image A) then type the formula(image B) then press enter
how to create formula?
a. press enter
b. click or type the name of the first cell to be merged
c. then use &"
d. press the space bar
e. then "&
f. click or type the name of the second cell to be merged


2. To copy the result, click on the cell where the formula is to be copied (image A) then dragged it to the cell where you want to copy the formula(image B)

0 comments: