TeachExcel.com
Video Tutorials, Macros, Shortcuts, and More...
TE
TeachExcel HD Video Tutorials for Microsoft Office Consulting Services Excel Help Now Contact Us
Excel Tips Excel Video Tutorials HD Video Tutorials for Excel Free Excel Macros
Video Tutorials
  • Free Macros
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • 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: Formulas
Featured Tutorial
Dynamically Update Drop-Dowm Menus in Excel
Featured Macro
Delete Empty Rows in Excel

Extract Text from Cells - Intermediate Example

Bookmark and Share
View all of our Excel Video Tutorials on our New YouTube Channel HERE.

This is a video tutorial that will show you how to use the FIND() LEN() LEFT() and RIGHT() functions to extract text and numbers from a cell in excel. This teaches you how to pull the text or numbers from the left side or the right side of a dash and to put the desired text in another cell through formulas. This is especially good for separating text from part numbers or employee lists.
   Topics Covered
Extract Text from Cells - Intermediate Example
Extract Text from the Left or Right Side of a Character like a Dash
FIND() and LEN() Functions
LEFT() and RIGHT() Functions
   Difficulty:         Intermediate
   Video:               Yes
   Spreadsheet:     Yes
Download Here:     1
Got a Question? Ask it Here in the Forum.
Contact | Privacy Policy | Disclaimer
Copyright© 2009 TeachExcel.com