How do you combine columns? There are basically two formulas you'll used to combine your columns. Say you have two columns i.e. employees First name and the second column Last name and you want to combine them into one column called Employee Names. The functions you can use will combine them, but then after you'll be stuck with the formula and not the actual values. Well, you could watch our Excel 2007 training videos to get right to the point, but if not know that one of the examples of the formulas to combine say to cells is the CONCATENATE formula. To see this in action or and how to deal with the results you please purchase our Excel Level 1 2007 video!

Purchase the training video and you can see this in action for yourself!