TeachExcel.com
Video Tutorials, Macros, Shortcuts, and More...
TE
Home Online Excel Classes Downloadable Tutorials & Guides Consulting Services Excel Help Now Contact Us
Excel Tips Excel Blog Excel Video Tutorials Excel Macros Forum
Video Tutorials
  • Free Macros
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Forum
  • Contact/About
  • New Excel Interface & Features
  • Getting Started with Excel 2007
  • Intro. to Formulas and Functions
  • Intermediate Formulas/Functions
  • Printing - Formatting - Saving
  • Sorting, Filtering, & Tables
  • Data Consolidation & Retrieval
  • Security in Excel 2007
Tutorials: Formatting
Featured Tutorial
Dynamically Update Drop-Dowm Menus in Excel
Featured Macro
Delete Empty Rows in Excel

Splitting Data from One Column into Multiple Columns

Bookmark and Share
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:    
Got a Question? Ask it Here in the Forum.
Contact | Privacy Policy | Disclaimer
Copyright© 2009 TeachExcel.com