http://www.freetutorialexcel.com
This short video shows you how to easily merge text (or concantenate text) from two cells into one. This is useful, for example, when you want to merge data from separate "First Name" and "Last Name" into a single, merged "Name" field.
http://www.freetutorialexcel.com