View all of our Excel Video Tutorials on our New YouTube Channel HERE.
How to break-up data from one column and transfer it to multiple columns in excel. Usefull for formatting data and organizing it in a predetermined way. Good for when you get, for instance, a list of employee data or addresses and they are in one column, but you want to seperate the data to break out the address from the rest of the employee information.
Topics Covered
 Left() Right() Mid() Functions  Compiling/Formatting Data  Putting Data from 1 Column into Multiple Columns  Separating Data
Difficulty: Intermediate
Video: Yes
Spreadsheet: Yes
Download Here:
|
|