Lesson 3-20 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)

Quality

LOW

Captions

OFF
Transcript

OFF

Speed

1x

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

Play The Video

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 | |

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. |