Separating and Combining Columns in Excel

Many student management systems have the ability to download an excel file with student information.  WE often need to manipulate the file to meet our needs.  

This video will show you how to take text that is one column and split it into two columns as well as taking two columns and combining them into one.

I hope this little trick saves you some time.  What other little tricks would help you?