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

3 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!

Blog Archive