JavaScript is disabled in your browser. Please enable JavaScript or upgrade to a JavaScript-capable browser to properly view this site. Thank you.

Monterey County Office of Education

Leadership, Support and Service to Prepare All Students for Success

Dr. Nancy Kotowski, County Superintendent of Schools

Course Description

Do you have a long list of cells in Excel like this:

John Doe 1 Main St. Anytown, USA 93992 555-555-5555

And want to be able to separate the name, address, and phone into separate cells? Well, with some complex formulas you can make it happen. Come to this training and I'll start you down the road of parsing data strings in Excel.

Prerequisite: Excel 200, 300, or a solid understanding of formulas.

Workbook

Resources

Contacts

Kudos Korner