PDA

View Full Version : Solved: Combining cells using a function key



bhunley
05-07-2007, 04:18 PM
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
05-07-2007, 04:43 PM
Here's a start for you

bhunley
05-08-2007, 03:08 PM
Hey Lucas, Thanks for your help. Using that I was able to get it working perfectly. My co-worker also says thanks.

lucas
05-08-2007, 03:10 PM
I like my pay in Vodka...:devil2: