This video will share how to join first and last names together using concatenate formula and the ampersand character. Also for those of you with Excel 2013, you will not want to miss watching the demo on flash fill. This is a great new feature that can save you a ton of time.
Practice on your own with my Concatenate.xlsx which is available in my OneDrive folder. Note that OneNote name has replaced SkyDrive.