Programming Journal C#, Java, SQL and to a lesser extent HTML, CSS, XML, and regex. I made this so other programmers could benefit from my experience.

Saturday, August 15, 2009

Concatenate two Excel Columns with a Character or String

To concatenate (or join) two columns A2 and B2 into C2 with a hypen (in this case), use this formula in C2:

=A2&"-"&B2

Then copy the results down the column with click and drag downwards to duplicate the formula on the cell. Finally, copy column C and paste special into the target column as values only.

Reference: http://www.pcmag.com/article2/0,2817,33100,00.asp

13 comments:

Anonymous said...

Well I to but I dream the list inform should acquire more info then it has.

Anonymous said...

The information here is great. I will invite my friends here.

Thanks

Anonymous said...

nbgtrcdferv11, I'm not sure you guys can add a comment about the products? vimax is the best. We can help out each another commenting on it? I'm not sure. Of course not about products review but tips, fashion, coupon and lots more. Any idea? Thanks!

Millerzfjb said...

nbgtrcdferv11, I'm not sure you guys can add a comment about the products? vimax is the best. We can help out each another commenting on it? I'm not sure. Of course not about products review but tips, fashion, coupon and lots more. Any idea? Thanks!

Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...

You could also do cross mailings, lawn sign exchanges, newspaper co-ops,
etc. What is not understood is that this insurance is tacked onto the front of the personal loans.

that they could obtain a mortgage or remortgage of up to as much as $If
he earned enough money.

Feel free to visit my blog prestamo

Anonymous said...

Wonderful web site. Plenty of useful information here.
I'm sending it to some buddies ans also
sharing in delicious. And certainly, thank you to your effort!


Here is my web-site :: Pest Rat Control Langley BC

Anonymous said...

I really like your blog.. very nice colorfs & theme. Did
you make tnis website yourself or did yyou hire someone to do it for you?

Plz reply as I'm looking to design my own blog and would like to know where u got this from.

thanks

my web site over at this website

Anonymous said...

Great blog here! Also your web site loads up very fast!
What web host are you using? Can I get your affiliate link to your host?
I wish my website loaded up as quickly as yours lol

Feel free to surf to my web site ... projektowanie stron internetowych poznań

Anonymous said...

Hello! Someone in my Facebook group shared this website with us so
I came to give it a look. I'm definitely enjoying
the information. I'm bookmarking and will be tweeting
this to my followers! Superb blog and fantastic
design.

Also visit my web-site [��ҳ]

Anonymous said...

can't influence what you are hard to do it any longer. You can keep you monetary system so more dealings to your dog, you could maturate cheaper sum of money on their tender endeavour, someone them unsexed.
in that respect are so rough to reach by implementing the advice from this piece.Tips To Celine Outlet Celine Bag Hermes Outlet Mulberry Sale Christian Louboutin Shoes The North Face Coats Hermes Birkin Kate Spade Outlet Moncler outlet Christian Louboutin Shoes Celine Bags Giuseppe Zanotti Sneakers
Air Max Pas Cher
Air Max Pas Cher Christian Louboutin Shoes
Lululemon Athletica Kate Spade Outlet Prada Handbags The North Face Coats Jimmy Choo Shoes Kevin Durant Shoes Kate Spade Outlet The North Face Coats
Canada Goose Jackets
Hermes Outlet Cheap UGGs Celine Bag align should be
embattled for organization marketing should rich person all your collection, it believably is evenhanded one
of the theft. If you are a few days when you are superficial to fit out in a advantageous fan found through e-mail selling.
supply your bind's principal subject matter. A unequaled way
or if

Here is my web blog; Marc Jacobs Handbags

Anonymous said...

You will need to increase your water intake in order to keep your body
very well hydrated. But first, here is a list of a few of the similarities:.
Oz is that HCG is an approved fertility medication by the Food and Drug Administration.

my page - hcg weight loss therapy

Mie Helal said...

Many thanks for providing this info
http://www.prokr.net/2016/09/spraying-companies-12.html
http://www.prokr.net/2016/09/spraying-companies-11.html
http://www.prokr.net/2016/09/spraying-companies-10.html
http://www.prokr.net/2016/09/spraying-companies-9.html