Solved: Combining cells using a function key

[bhunley]

I have attached an excel file showing what I am trying to do, sorta. I have 4 columns: name, address1, address2, and combined. I am trying to figure out how to take the first 3 columns and combine them and display them in column 4 in a stacked fashion. Is this possible? Also, I need it to do it only on the row currently selected. I hope this is clear enough. I would like this to happen through the use of a macro or function key press.

This is for one of my co-workers, and I have little experience with excel. Anything will help. Thanks.

B

[lucas]

Here's a start for you

[bhunley]

Hey Lucas, Thanks for your help. Using that I was able to get it working perfectly. My co-worker also says thanks.

[lucas]

I like my pay in Vodka...