Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Extract Text from Cells - Intermediate Example

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

Got a Question? Ask it Here in the Forum.