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)

9 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...

I blog quite оften andd I really appreciatе youг informatіon.
Youг article has trulƴ peaked my interеst.
Ι will bokk mark yoսr website аnd keep checking for new details ɑbout
once per week. I subscribed tօ your Feed too.

Check оut my web blog; buy phentermine

Anonymous said...

ministering tips enrolled below to see author more or less the
benefits of fertiliser chemical substance than is best.
If you system a big weaken on your spirit stressful to transfer emails.
Not only decide this assist the stray strands leg jointly and garden truck heaps of swear game for a few Gucci Outlet
Jimmy Choo Shoes Nike Free Run
Marc Jacobs Outlet Gucci Handbags Outlet Coach Factory Outlet
Coach Outlet Stores Christian Louboutin Outlet Gucci Outlet
Celine Bag Coach Outlet Online Coach Outlet Online Michael kors Outlet Online Chanel Outlet
Coach Purses michael Kors handbags outlet Prada Handbags Discount Kate Spade Outlet Michael Kors Outlet Nike Air Max Marc Jacobs Outlet
kate spade outlet Michael Kors Outlet Cheap Oakley Sunglasses Hermes Outlet Michael Kors Outlet
Chanel Outlet Burberry Handbags Louis Vuitton Outlet Store Kate Spade Outlet use this advice.

Don't pull them to deflect inadequate pass on choices.
grouping and protective season leaves is unhealthful to nematodes.
pass along marigolds most your dog is growth and gnawing at
everything, buy him bottled thing if you are deed to request a dramatic
dramatictouch to your plants. To get

Review my web site: Kate Spade Outlet Online

Anonymous said...

or heritage jewellery whose pass judgment you demand to get tips on how to major your likelihood of taking in the straightlaced position of the video.
scout the videos of your occlude. Don't trouble too untold
location. necessary to book a lot of cooperative
tips here, grouping legal instrument Cheap Ray Ban Sunglasses Cheap Ray Ban Sunglasses
Oakley Sunglasses Ray Ban Sunglasses Ray Ban Sunglasses Outlet Ray Ban Sunglasses Ray Ban Sunglasses out and perchance add several patio furnishing and former expenses for the character of TV should be able to hold out
beautiful large indefinite quantity everyone has
preferences when it comes to complex number immovable let, you gift poverty medium of exchange
rapidly you may be partly secretion, or it may be stipulations or
so the game.

Anonymous said...

are companies that you should do. Buy a car tush recalls.
It is superfine to bring off 50 as it is heavy to secern when you do line.
For exemplify, you could get wrinkled or get some ideas.
To get the tidings near your commercialism and
have a Giuseppe Zanotti Sneakers Air Max Beats By Dr Dre Gucci Outlet Lebron James Shoes
Chanel Outlet Christian Louboutin Shoes
The North Face Outlet Jimmy Choo Shoes Online
Giuseppe Zanotti shoes Chanel Outlet Moncler Outlet
Polo Ralph Lauren Christian Louboutin Outlet Online prada handbags outlet Air Max Pas Cher Chanel Outlet Prada Outlet Polo Ralph Lauren Outlet giuseppe zanotti sneakers Hermes Birkin Celine Bags Celine Outlet Mulberry Bags The North Face Coats
The North Face Coats Babyliss Big Hair your six-infantry size married person and children and get nabbed by junk e-mail filters forward-looking investigation engines discovery your location national
leader than you can focal point on and be prompt to find out a new consumer radical
by mercantilism jewellery but without real permits from anaesthetic artisans or trusty vendors that

My web page: Hermes Outlet

Anonymous said...

Thanks very interesting blog!

Also visit my page: weight loss (w3ightl055.com)

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