See more Excel demos at http://office.microsoft.com/en-us/help/FX100485311033.aspx
Do you ever want to combine the contents of several cells into one cell? Say you have a worksheet of employee names, with first and last names in separate columns, but you want both names in the same column. Excel offers two different formula methods for doing just that. Watch the demo and see how to use a fast formula to save yourself lots of time and typing.