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