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)

5 comments:

Anonymous said...

Guild achievements are accomplished by killing
bosses, obtaining membership demographics, and
a number of other activities. The progression of the Eversong Woods is to first complete all of the quests in Sunstrider Isle.
A total of 1,672 young adults aged 21-25 were polled, each of whom was in a co-habiting relationship and had been living with their partner in the same
rented accommodation for at least two years.

Feel free to surf to my blog Hearthstone hack

Anonymous said...

Hurrah! At last I got a website from where I be capable of truly
get helpful facts concerning my study and knowledge.


Review my web blog ... livejasmin hack

Anonymous said...

electronic cigarette, e cigarette health, smokeless cigarettes, e cigarette, ecigarette, electronic cigarettes reviews

Anonymous said...

smokeless cigarettes, smokeless cigarette, vapor cigarette, e cig reviews, e cigarette, smokeless cigarettes

Anonymous said...

replica bags from korea websites s1m18e7e38 replica bags by joy i was reading this d5x48i3s85 high quality designer replica replica radley bags r1b80p7l69 replica bags on amazon replica hermes bags k7y36b2b10 replica bags blog