Home Sample Files
Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills
2016 2013 2010 2007 Apple Mac

Extract text from strings using the LEFT, RIGHT and MID functions:

Lesson 3-20 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)
Extract text from strings using the LEFT, RIGHT and MID functions
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2013 Expert Skills
Session: Session 3: Advanced Functions
Lesson: Lesson 3-20 Extract text from strings using the LEFT, RIGHT and MID functions Excel 2013 Expert Skills Lesson 3-20 Extract text from fixed width strings using the LEFT, RIGHT and MID functions
Description:

This video lesson demonstrates how to use the LEFT, RIGHT and MID functions in Microsoft Excel formulas. In this lesson's example, the LEFT, RIGHT and MID functions are used to split an ISBN number into its component values. This lesson also explains how to convert text results into numerical results and how to use LEFT, RIGHT and MID with values that contain formatting characters. You'll also learn about some alternative ways to achieve the same result using Excel's Flash Fill and Text to Columns features.

Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email