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)
Oath Taking of New 2012 Librarians - To All New Librarians, Please be informed that the oath taking will be held on Dec. 6, 2012 at 1:00 PM at the Manila Hotel. On the said activity, the Phil...
4 years ago