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

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

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 [��าณ]

Unknown 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