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:
Post a Comment