This video tutorial will show you how to use the FIND() LEN() and LEFT() RIGHT() and MID() functions to extract a first, middle, or last name from a cell in excel. These are advanced formulas and they can be applied to any situation where you need to pull something from the first, middle, or last position of a cell such as an employee list or parts list. This tutorial will go in depth to explain what the FIND() and LEN() functions are and how and where you would use them in formulas.
Formulas hard to read? Download the accompanying spreadsheet - located in the second box below.
Topics Covered
 FIND() & LEN() Functions
Advanced Methods to Extract Text from Cells
Extract the First, Middle, and Last name from a Cell
Difficulty: Advanced
Video: Yes
Spreadsheet: Yes Download
|
