Concatenate columns

I'm a huge fan of the user defined function concrange (concatenate range). I use it all the time. Try it out, you'll love it.

Here's where you can find it:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=817